I need to have a sequential value labeling the number of identical values in a list. For example if I have FB1, FB1, FB1, FB1 in rows A1:A4, I need it to say 1,2,3,4 respectively in rows B1:B4. Then in row A5 when a unique value of FB2 starts, I need the counter to start over at 1 again. How do I do this?
mster4210,
Welcome to the forum!
In cell B1:
=COUNTIF($A$1:A1,A1)
And then copy down.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
worked perfectly thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks