Hi,
I want to have running number (wonder if it is the correct term) only for unique values.
Attached is a sample of what I intend to do.
I can do aBut it breaks when B2=A2, so I cannot simply drag the formula down.
Please Login or Register to view this content.
Can someone point me to a function that can help me achieve this?
Thank you
I can follow that explanation. so, use this
=IF(COUNTIF(B$4:B4,B4)=1,MAX(A$3:A3)+1,"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks