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

    Extracting String from a data with string

    Hey all , need urgent help.I am stuck with a VBA project because of this problem.I got a set of data which is seperated by symbol "/", the code i am trying to build is if cell value is for eg ABC0604082/00797983 then result should be 00797983 if cell value is ABC0604082/ then result should be...
  2. R

    To find Duplicate Value to highlight the 2nd duplicate value not both

    Thank you chandoo for your help, i am going to incorporate this into my tracker & see how it works :) hopefully i'll not goof it up Btw do you still take Donuts? :D
  3. R

    To find Duplicate Value to highlight the 2nd duplicate value not both

    Need an urgent help,i am strugglin with a simple objective but don't know how to make excel work & get that result. I have to make an excel tracker for invoices recieved which will help us to track the number of duplicate invoices recieved.What i'd done is to combine 4 unique headers(=invoice...
  4. R

    Data consolidation Macro

    Thank you Hui.i learn soo much here
  5. R

    Data consolidation Macro

    more than the code,i want to understand the logic behind it,so that i can write it myself.i'm a newbie in vba
  6. R

    Data consolidation Macro

    i would like to know 2 things 1.how you keep on adding data to an excel sheet.Suppose today you added data to excel & next date the data has to be entered from the cell below the last data is added. 2.Instead of picking up data from a certain coloumn, can we write a code where it'll pickup...
  7. R

    define lookup reference functions

    Thank you Narayan :)
  8. R

    define lookup reference functions

    hello, i've just joined office n startd using excel.i understand vlookup & hlookup but i don't have a clue when to use the other functions,so i was wondering can anyone explain When is a "lookup","index","indirect","Offset","Match","Row" & "Rows" function is used.as you can sense i already went...
Back
Top