Ranking Duplicate values

StephenVWard

New Member
Joined
May 3, 2013
Messages
1
Please help. Thank you in advance. I am looking to rank only duplicates in a list on a different column criteria based on date. If their are no duplicates it would stay at 1. If duplicates, it would rank based on date in a decending or ascending order. For example.

Column A has values:
237
176
876
237
176
237
237

Column B has a date
2/1/13
2/1/13
2/1/13
5/6/13
5/12/13
8/10/13
9/8/13

Looking to get the following on Column C
1
1
1
2
2
3
4
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

joemeshuggah

Board Regular
Joined
Jul 18, 2008
Messages
161
if your dates in column b are always in chronological order, this would work =COUNTIF(A$1:A1,A1)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,741
Members
414,171
Latest member
12Rev79

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