• 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.

Recent content by vicmoment

  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.
See more
Back
Top