| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
unique records
Is there a formula to determine the number of unique items in a columm?
|
|
#2
|
|||
|
|||
|
=SUM(IF(A1:A10<"",1/COUNTIF(A1:A10,A1:A10))) ...entered using CONTROL+SHIFT+ENTER. Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=275277 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
| In Excel: If I know a file has 147,000 records, but Excel will on. | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
