Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning rank or appearance
I have a data table something like this but much larger.
Currently column C is empty. I want to return next to each item what position it is. i.e. in line 3, apple has appeared once already, so the value should be 2. Any ideas??? ColA ColB ColC Apple 34 1 Orange 42 1 Apple 85 2 Apple 54 3 Orange 24 2 Peach 87 1 Peach 91 2 Orange 75 3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning rank or appearance
Assuming the first "apple" to be in A1:
=COUNTIF($A$1:A1,A1) will do what you ask for best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sarah" wrote in message ... I have a data table something like this but much larger. Currently column C is empty. I want to return next to each item what position it is. i.e. in line 3, apple has appeared once already, so the value should be 2. Any ideas??? ColA ColB ColC Apple 34 1 Orange 42 1 Apple 85 2 Apple 54 3 Orange 24 2 Peach 87 1 Peach 91 2 Orange 75 3 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning rank or appearance
That's awesome - thanks!!!
"Bernard Liengme" wrote: Assuming the first "apple" to be in A1: =COUNTIF($A$1:A1,A1) will do what you ask for best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sarah" wrote in message ... I have a data table something like this but much larger. Currently column C is empty. I want to return next to each item what position it is. i.e. in line 3, apple has appeared once already, so the value should be 2. Any ideas??? ColA ColB ColC Apple 34 1 Orange 42 1 Apple 85 2 Apple 54 3 Orange 24 2 Peach 87 1 Peach 91 2 Orange 75 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank & Group Tournament | Excel Discussion (Misc queries) | |||
RANK Function - Zero Value Ranked as 1 - Should be 10 | Excel Worksheet Functions | |||
Can I Rank on a second criteria if the first is equal? | Excel Discussion (Misc queries) | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
RANK formula | Excel Discussion (Misc queries) |