• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Index Match problem

    just curious, would a simple vlookup not work say = IFERROR(VLOOKUP(sheet1!FM2,Sheet2!$A$2:$D$4,4,0),"")
  2. V

    Copy data inbetween certain rows and paste as transposed

    Hi Bob, You are all welcome...different ways to kill a monkey I guess
  3. V

    Copy data inbetween certain rows and paste as transposed

    Thanks so much. It works perfectly Its funny that after posting on chandoo.org, i was then able to write a code to perform the task see https://docs.google.com/open?id=0B32orugVlNhDT01UeGtsMGhkMmc See Module 3 in the attached file for the Macro I wrote I really appreciate this. Thanks...
  4. V

    Copy data inbetween certain rows and paste as transposed

    I have a spreadsheet that has all the data in column A. A special character "|" marks the end of an entry, all entries dont have same number of rows. What i want to do is to copy rows inbetween two "|" characters and paste transposed on another sheet. See sample worksheet in...
  5. V

    Sir How to derive name from the following string.

    I totally agree with Luke M
  6. V

    Sir How to derive name from the following string.

    This should work I guess =RIGHT(A1,LEN(A1)-FIND(":",A1)-1) @sachin: You used find("-"), I should think that would be find(":")
  7. V

    User Form

    I meant room 3 in row 3 and not 2 as shown in my last post Thanks for the feedback.
  8. V

    User Form

    I could not open your sample file maybe thats where the mix up is coming from. In my smaple sheet, when i put a room number as 3, it fills the data in row 2, room number 4, fills data in row 4. Maybe you could explain again.
  9. V

    User Form

    Hi sunny, See example in my excel worksheet https://docs.google.com/open?id=0B32orugVlNhDa3doRkVMM0QySVU Let me know what you think
  10. V

    Running Balance/total using Excel VBA

    You ate definitely right about the value in D15, pasted in ahurry. I agree with your suggestion on not using VBA, i only wanted to see how it could be done with it. Are you familiar with ACL(Audit command language). Performing a similar task must be done with a script, so i only wanted to see...
  11. V

    Logic with Dates

    If I understand you correctly,you want every cell in that range to be equal the minimum in that range. You can write in colum B: =min($A$1:$A$5) Let me know if this meets your needs
  12. V

    Formula for: If something is in here then add the corresponding

    Sample data would have been good. You said sum the corresponding cell in that row, sum it to what please? Try using a sumif if you just need an overall sum. =sumif(S1:S31,"JOHN BLUE",A1:A31) Please let me know if this meets ur needs
  13. V

    Running Balance/total using Excel VBA

    formula and VBA solutions are both welcome but more interested in VBA. Thanks
  14. V

    Running Balance/total using Excel VBA

    See the spreadsheet in the link below. I want to do a running balance for each account. When the account changes, the sum is reset and continues to sum up till it gets to the next change in account. the link is...
  15. V

    Formula to extract Name that appears most frequently in a List

    HI Narayan, You are simply amazing. It works except when there's a tie which is good itself I have not been able to wrap my head around the magic going on there so if you could break the formula down a bit, that would be fine.
  16. V

    Formula to extract Name that appears most frequently in a List

    Faseeh, Thanks for your observation. Iknow its not full proof but I would like to at least be able to return one of them, i probably would then think of extending it to accomodate ties
  17. V

    Formula to extract Name that appears most frequently in a List

    Narayank/Cyril I am sorry about the permission thingy, I have modified the access. https://docs.google.com/spreadsheet/ccc?key=0An2orugVlNhDdEV4R1owbFk4Z1RSY19KbWd3TENSRHc&pli=1#gid=0 Sorry for the inconvenience
  18. V

    Formula to extract Name that appears most frequently in a List

    Hi Narayank, Pls try this https://docs.google.com/spreadsheet/ccc?key=0An2orugVlNhDdEV4R1owbFk4Z1RSY19KbWd3TENSRHc&pli=1#gid=0 What I need is to rreturn the player name that appears most frequently for each club
  19. V

    Formula to extract Name that appears most frequently in a List

    I have a list wth player names and their clubs. I have a dropdown in another sheet from which I select the club whose records i want to see. I want to be able to select a club and with a formula to know whose name appears most frequently in the list. See sample workbook in...
  20. V

    Function to rearrange/shuffle a word in excel

    Thanks so much for the explanations. What prevents the collection from not accepting same Cstr(R)? That was the part that made me ask for explanations in the first place.
  21. V

    Function to rearrange/shuffle a word in excel

    PLease help explain this part of the code CL.Add R, CStr(R) Thanks
  22. V

    Function to rearrange/shuffle a word in excel

    You guys are out of this world. Brilliant. Thanks
  23. V

    Function to rearrange/shuffle a word in excel

    Please I need help creating a function that can shuffle the characters of a word. e.g Peak as kepa, faithful as thfaiutl Trust that the gurus would solve it
  24. V

    Summing columns with repetition

    From what i see LARGE,MIN and SMALL dont seem to work when the cell is blank like you rightly put it. So it seems iferror would come in handy or some other IF statements. SO the formula in my last post profuces an error
  25. V

    Summing columns with repetition

    very well said. Will digest your comments later. So we could just use large(E7:G7,3) in place of min. Then we have =MAX(LARGE(E7:G7,3),LARGE(H7:J7,2),K7,L7,M7)
Back
Top