| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count number of instances of same data
Hello,
I have a worksheet with 2159 rows. Each row contains 2 columns (name and number) with many duplicates. I want to end up with a report that shows 3 columns (name, number, instances) where there are no duplicates but the instances column shows the number of times each name and number appears. I think a pivot table is the solution but I can't get it to do what I want. Can anyone help me with this? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count number of instances of same data
Never mind, I figured it out.
Thanks anyway! "George" wrote: Hello, I have a worksheet with 2159 rows. Each row contains 2 columns (name and number) with many duplicates. I want to end up with a report that shows 3 columns (name, number, instances) where there are no duplicates but the instances column shows the number of times each name and number appears. I think a pivot table is the solution but I can't get it to do what I want. Can anyone help me with this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of instances a number occurs | Excel Worksheet Functions | |||
| Count the number of Instances | Excel Discussion (Misc queries) | |||
| In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
| Count Instances | Excel Discussion (Misc queries) | |||
| Count number of instances in sheet e.g. how many males/females | Excel Worksheet Functions | |||
Linear Mode
