Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi, I just updated the image...
Something like this...
Data Range
A B 1 ------ ------ 2 Name 1 4 3 Name 1 4 Name 1 5 Name 1 6 Name 2 1 7 Name 3 4 8 Name 3 9 Name 3 10 Name 3 11 Name 4 2 12 Name 4 13 Name 5 3 14 Name 5 15 Name 5
This formula entered in B2 and copied down as needed:
=IF(A2=A1,"",COUNTIF(A:A,A2))
Then, convert the formulas to constant values...
Select the entire range of formulas
Right click>Copy
Right click>Paste Special>Values>OK
Then you can delete the rows without a count value in column B.
You can probably filter for blanks in column B then delete those rows.
Wow that worked great and exactly as I needed.
Can you please do me a one last help?
The "1" should be "0", 2 should be 1, 3 should be 2, 4 should be 3 and so on...
Is there a formula for that as well?
Maybe use this formula instead:
=IF(A2=A1,"",COUNTIF(A:A,A2)-1)
Hi, worked exactly as I needed..
Thanks a lot for the help Tony. God bless you!
You're welcome. Thanks for the feedback!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks