Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number an item appears
I am trying to place a number next to an item for every time it appears, any
suggestions? ex: apple 1 orange 1 grape 1 apple 2 apple 3 orange 2 kiwi 1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number an item appears
Assuming your data starts in cell A1, enter this formula in B1 and copy down
as needed: =COUNTIF(A$1:A1,A1) -- Biff Microsoft Excel MVP "klh84" wrote in message ... I am trying to place a number next to an item for every time it appears, any suggestions? ex: apple 1 orange 1 grape 1 apple 2 apple 3 orange 2 kiwi 1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number an item appears
In B1 enter 1
in B2 enter: =COUNTIF(A$1:A2,A2) and copy down -- Gary''s Student - gsnu201001 "klh84" wrote: I am trying to place a number next to an item for every time it appears, any suggestions? ex: apple 1 orange 1 grape 1 apple 2 apple 3 orange 2 kiwi 1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number an item appears
Put this in B1:
=COUNTIF(A$1:A1,A1) and copy down. Hope this helps. Pete On Feb 25, 6:53*pm, klh84 wrote: I am trying to place a number next to an item for every time it appears, any suggestions? ex: apple * * 1 orange * 1 grape * * 1 apple * * 2 apple * * 3 orange * 2 kiwi * * * 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the times a number appears | Excel Discussion (Misc queries) | |||
counting the number of times a word appears | Excel Worksheet Functions | |||
Counting the number of times a word appears 'anywhere' on a page | New Users to Excel | |||
Counting number of time a character appears in a string | Excel Worksheet Functions | |||
Counting the number of times a word appears in a worksheet | Excel Worksheet Functions |