Getting the count or # of occurrences of a value, but counting up to it

joshuaba

New Member
Joined
Mar 6, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi guys,
I need help in trying to get a "rank" of text.
Let me explain.
I have a spreadsheet where column A has repeating values, while column B shows the rank/count of these values.

I have attached a screenshot of a simple example.

The letter A shows up a total of 3 times, and column B is counting 1,2,3. Meanwhile letter D is showing up 8 times, and counting 1 through 8.

Can you advise? I feel like there is a simple way of calculating this but I can't figure it out.
 

Attachments

  • Capture.JPG
    Capture.JPG
    14 KB · Views: 6

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Not really sure what your question is. If column B is your expected result, then this. (If not please give an example of expected results).

Book2
AB
1LETTERSLOT/RANK
2A1
3A2
4A3
5B1
6B2
7B3
8B4
9C1
10C2
11D1
12D2
13D3
14D4
15D5
16D6
17D7
18D8
Sheet3
Cell Formulas
RangeFormula
B2:B18B2=COUNTIF($A$2:A2,A2)
 
Upvote 0
Nevermind, I solved it with a modified countif...I knew it had something to do with it!

=COUNTIF($A$2:A2, A2)
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

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
Back
Top