Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells with same data
I have a worksheet with over 50,000 rows but only approximately 3,000 unique
rows. The rest are the same data with different qty or category, etc. (Column 1 = Data, Column 2 = Category, Column 3 = qty) Is there a way to filter the sheet by each unique cell, hide the duplicates, and give a total of how many duplicates? The columns consist of part #, qty sold, category, date, time... I just want a total of each part number and how many were sold regardless of the category, date, time. Thanks, Wayne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells with multiple data | Excel Worksheet Functions | |||
Counting cells that contain data | Excel Discussion (Misc queries) | |||
Counting cells with data | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
counting cells in a data range that meet 3 specific conditions | Excel Discussion (Misc queries) |