| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique (30000 rows) using criteria - Please help!
In Sheet1 I have:
ColE ColB 1/1/08 00113800 1/1/08 02559000 1/2/08 00113800 1/2/08 02559000 1/2/08 02559000 1/3/08 00113800 1/3/08 02559000 In Sheet2 I Need: ColA ColB 1/1/08 2 1/2/08 2 1/3/08 2 How can I count unique values on one sheet using criteria from another? Also, this needs to work on 30,000 rows on Sheet1. I tried a few solutions from what I found on the newsgroups (using arrays) and it locked up Excel. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values with a Criteria | Excel Worksheet Functions | |||
| Count unique numbers in a range with a given criteria | Excel Discussion (Misc queries) | |||
| count unique with mulitple criteria | Excel Worksheet Functions | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| how to count unique values in excel based on criteria | Excel Worksheet Functions | |||
Threaded Mode
