| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting unique records
I am trying to count unique entries in one filtered column of a multi column,
multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
Maybe..........
=SUBTOTAL(3,A:A) Vaya con Dios, Chuck, CABGx3 "yhtak" wrote: I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
You can do this with a pivot table. Have you tried that?
"yhtak" wrote: I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
I assume you mean the number of times a given entry appears in the whole
list. If this is what you want: Try using the COUNTIF function. In row 1 of some empty column type: =COUNTIF($A$1:$A$3000,A1) and copy it down as far as your data goes. This assumes that the column you want to count is Column A. As written, this formula assumes you have 3000 entries. Change that to your actual number of entries. The formula produces a number in every cell that has the formula. That number is the number of entries that your list has of the entry in Column A in the same row. In other words, if row 17, Column A, has "Hello" in it, the cell in row 17 of the column that has the formulas will have the number of times that "hello" appears in your list. HTH Otto "yhtak" wrote in message ... I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
No, I havent... sadly I have v. limited knowledge of pivot tables.
"Barb Reinhardt" wrote: You can do this with a pivot table. Have you tried that? "yhtak" wrote: I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
No, I haven't... sadly I have v. limited knowledge of pivot tables.
"Barb Reinhardt" wrote: You can do this with a pivot table. Have you tried that? "yhtak" wrote: I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting unique records
"yhtak" wrote in message
... I am trying to count unique entries in one filtered column of a multi column, multi-row spreadsheet. Is this possible? e.g. 872T56OM17 872T56OM17 872T56OH17 etc etc (up to 26K rows) Thanks is advance See http://www.contextures.com/xlFunctions04.html#Visible Bruno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Unique Records from two lists | Excel Worksheet Functions | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
| Counting unique records with additional criteria | Excel Worksheet Functions | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Linear Mode
