| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count
I have a spreadsheet with a couple of hundred names entered once, twice or
three times. Now I want to count the how many different names there are. How do I do so. Thanks Henk |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count
Hi,
Try this with the range altered to suit. Note the range cannot contain blank cells =SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1: A10,A1:A10,0))0,1)) Mike "hemusta" wrote: I have a spreadsheet with a couple of hundred names entered once, twice or three times. Now I want to count the how many different names there are. How do I do so. Thanks Henk |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count
Try this:
=SUMPRODUCT((A1:A200<"")/COUNTIF(A1:A200,A1:A200&"")) -- Biff Microsoft Excel MVP "hemusta" wrote in message ... I have a spreadsheet with a couple of hundred names entered once, twice or three times. Now I want to count the how many different names there are. How do I do so. Thanks Henk |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count
Hi,
This doesn't cover all the bases but may meet your needs: =SUMPRODUCT(1/COUNTIF(C1:C9,C1:C9)) Where C1:C9 is the range with names. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "hemusta" wrote: I have a spreadsheet with a couple of hundred names entered once, twice or three times. Now I want to count the how many different names there are. How do I do so. Thanks Henk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
