Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting item in a column
Hi
I have a spread sheet where there is a column with over 3000 cells, there are 90 items, some appearing often and some only a few times. Is there a way I can sort the column by the number of time an item appears, or to highlight how many time each item appears. thanks Daniel |
#2
|
|||
|
|||
Hi Daniel
Assuming your data is in A2:A3000 then in B2 enter =COUNTIF($A$2:$A$3000,A2) and copy down. This will give you the count for each item. You can then sort by column B. Hope this helps Rowan "Daniel - Sydney" wrote: Hi I have a spread sheet where there is a column with over 3000 cells, there are 90 items, some appearing often and some only a few times. Is there a way I can sort the column by the number of time an item appears, or to highlight how many time each item appears. thanks Daniel |
#3
|
|||
|
|||
Great,
thank for the fast reply Daniel "Rowan" wrote: Hi Daniel Assuming your data is in A2:A3000 then in B2 enter =COUNTIF($A$2:$A$3000,A2) and copy down. This will give you the count for each item. You can then sort by column B. Hope this helps Rowan "Daniel - Sydney" wrote: Hi I have a spread sheet where there is a column with over 3000 cells, there are 90 items, some appearing often and some only a few times. Is there a way I can sort the column by the number of time an item appears, or to highlight how many time each item appears. thanks Daniel |
#4
|
|||
|
|||
You're welcome.
"Daniel - Sydney" wrote: Great, thank for the fast reply Daniel "Rowan" wrote: Hi Daniel Assuming your data is in A2:A3000 then in B2 enter =COUNTIF($A$2:$A$3000,A2) and copy down. This will give you the count for each item. You can then sort by column B. Hope this helps Rowan "Daniel - Sydney" wrote: Hi I have a spread sheet where there is a column with over 3000 cells, there are 90 items, some appearing often and some only a few times. Is there a way I can sort the column by the number of time an item appears, or to highlight how many time each item appears. thanks Daniel |
#5
|
|||
|
|||
Lets say your items are in the range A1:A10, then in column B, cell B1 enter
=COUNTIF($A$1:$A$10,A1) And drag down for the entire range. Then select both the ranges, go to Data Sort based on column B ascending. Mangesh "Daniel - Sydney" <Daniel - wrote in message ... Hi I have a spread sheet where there is a column with over 3000 cells, there are 90 items, some appearing often and some only a few times. Is there a way I can sort the column by the number of time an item appears, or to highlight how many time each item appears. thanks Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
counting similar items in a column | Excel Discussion (Misc queries) | |||
counting only specific numbers in column | Excel Worksheet Functions | |||
Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |