Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here is my data (in actuality, it's about 35,000 rows long and will be
growing at the rate of 1,000 rows per month) and it's in a sheet I've labeled as "Format 1". TYPE (column A) PERIOD (column B) VERSION (column C) DS 02/2005 1 BS 02/2005 2 WS 03/2005 2 DS 02/2005 1 I want to be able to count all of the different combinations that occur (i.e., count all of the "DS and 02/2005 and 1") and return them in a sheet I've labeled "Results" There is too much data for a pivot table and I know there's a solution using sumproduct (or something like that), but I haven't been able to figure it out. Any ideas? Thanks, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |