Labeling Duplicate data in a column

hanahass

New Member
Joined
Jul 25, 2021
Messages
20
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi Masters!

Seeking your expertise to help me with this if i have, for example :

A
A
A
B
B
C
C
D
D
D

and I need the next to be labelled as their order from top to bottom like the image attached

Not sure if this is confusing but, please let me know.

Thanks in advance!
 

Attachments

  • Capture.PNG
    Capture.PNG
    1.5 KB · Views: 3

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
51,698
Office Version
  1. 365
Platform
  1. Windows
Like this?

21 08 31.xlsm
AB
1A1
2A2
3A3
4B1
5B2
6C1
7C2
8D1
9D2
10D3
Number Them
Cell Formulas
RangeFormula
B1:B10B1=COUNTIF(A$1:A1,A1)
 
Solution

hanahass

New Member
Joined
Jul 25, 2021
Messages
20
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi Peter! Thank you for your reply!

If I use countif, it'll be

A 3
A 3
A 3
B 2
B 2

instead of

A 1
A 2
A 3
B 1
B 2
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
51,698
Office Version
  1. 365
Platform
  1. Windows
If I use countif, it'll be

A 3
A 3
A 3
B 2
B 2
No it wont, you can see it working in my mini-sheet.
Try it. Make sure that you use the formula I gave (assuming the data is in columns A:B as shown in my sheet), not the one you think I gave. :)
 

hanahass

New Member
Joined
Jul 25, 2021
Messages
20
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Oh yes! Sorry! I didn't notice it was a mini-sheet. I got it now! and it's perfect!

Thank you so much Peter! I appreciate you! 🙇‍♀️
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
51,698
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Glad you got it sorted. :)
 

Forum statistics

Threads
1,147,482
Messages
5,741,404
Members
423,657
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top