Ask Your Question
0

how to number rows based on duplicate cell values?

asked 2016-01-21 17:12:05 +0100

blukraken gravatar image

I need to number rows based on duplicate values in a different row. i.e.

  1. Column A (the #) ---Column B (The Duplicates)
  2. 1------------------------CC111
  3. 2------------------------CC111
  4. 3------------------------CC111
  5. 1------------------------AE231
  6. 2------------------------AE231
  7. 1------------------------BB456
  8. 1------------------------DD444
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-01-26 13:05:06 +0100

JohnSUN gravatar image

Write to A2 formula =COUNTIF($B$1:B2;B2) and drag it down

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-01-21 17:02:46 +0100

Seen: 44 times

Last updated: Jan 26 '16