CODEWITHSUNDEEP
excelexcel-formuladuplicatesformularanking
g_PD
g_PD

Reputation: 1

Ranking Duplicate String Values in Excel

I have a spreadsheet with string values and need to create a column with the rank (without using the rank function) of the duplicate values from another column. Please see below for example of the desired outcome where Dupe_Rank is the created column.

Thanks!

Name Dupe_Rank
John 1
John 2
Dave 1
John 3
Bill 1
Dave 2

Upvotes: 0

Views: 537

Answers (1)

Ankush G
Ankush G

Reputation: 1081

let's say "Name" starts from column 'A' and row 2 as in below figure:

enter image description here

then add this formula:

=COUNTIF(A$2:A2,A2)

to cells below Dupe_Rank and then drag(or copy-paste) this formula to all the cells

enter image description here

Upvotes: 1

Related Questions