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.
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.
