I have a worksheet (brief copy attached) that has duplicate data "h" that I want to assign a sequential number to the left column of. 1st "h" 1, 2nd "h" 2 and so on to be used for a vlookup function in another sheet.This sheet is constantly growing with an copy/insert macro I created so I need it to expand as other entries "h" are made. Here is a before and after example.
Last edited by mlopardo; 07-08-2010 at 04:13 PM.
Do you mean something like:
=IF(B3="h",COUNTIF(B$3:B3,"h"),"")
copied down as far as you want so that when you add more, the formula is already in column A.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank You!! Works beautifully. Sometimes the easiest solutions are the most elusive.
Last edited by mlopardo; 07-08-2010 at 04:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks