I need a formula to increase the value cell "C" if it the same value exists else where example below. I need a formula to create column "C"...
If anyone could help I would be very happy!
Column B
W8501520254
W8501520354
W8501520554
W8501520654
W01851200P3
W01851201P3
W01851250P3
W01820202P3
W01820200P3
Column C
W8501520254-001
W8501520354-002
W8501520554-003
W8501520654-004
W01851200P3-001
W01851201P3-002
W01851250P3-003
W01820202P3-004
W01820200P3-005
In C1 copied down
=B1&"-"&TEXT(COUNTIF($$B$1:B1),B1),"000")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That does work but I noticed I didn't need this as the numbers were not the same... Thanks anyways though...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks