sequential numbering duplicate data

[mlopardo]

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.

[Paul]

Hi Mlopardo, welcome to the forum.

Please post a sample sheet that shows a before AND after view of how your data should look. I can't tell if you simply want numbers in column A any time the letter "h" appears in column B, if you want the same to apply to any repeated letter or number in column B, etc..

[Paul]

Thanks for updating the spreadsheet, Mlopardo.

In A3 put this formula:

=IF(B3="h",COUNTIF($B$3:B3,"h"),"")

Fill that down column A as far as necessary and you should see your numbers.