| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count unique items in ever-growing list?
Hey all -
I'm trying to count the number of albums I have digitized. I have a series of columns with album info as exported from iTunes. One of the columns lists Album Name but the album name is repeated for each record (in this case each Song). I just want to know how many albums I have in the list. I tried using the formula suggested in another similar post [=SUMPRODUCT((Data!D2:D1413<"")/COUNTIF(Data!D2:D1413,Data!D2:D1413&""))] but this requires me to continually update the max range value (i.e. "D14138") as I import more records. Is there a formula that does the same thing but can handle empty cells? (so I can put in something like "D9999" for the max range value) thanks in advance!!! meat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best way to get a list of unique entries in a field | Excel Worksheet Functions | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
| How do I delete items in one list from another list? | Excel Discussion (Misc queries) | |||
| count unique with conditions | Excel Worksheet Functions | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Threaded Mode
