| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count # of unique occurances
I have a list that show mulitple times in my spreedsheet and I need to know how many actual numbers are there Ex: I actually have 5 orders here. 398805 398805 398805 516878 516878 516878 540836 540836 540836 540836 540836 567585 567585 567585 567585 567911 567911 567911 567911 Thanks for your help -- sharder ------------------------------------------------------------------------ sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488 View this thread: http://www.excelforum.com/showthread...hreadid=556605 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count # of unique occurances
Hi!
Try this: =SUMPRODUCT((A1:A19<"")/COUNTIF(A1:A19,A1:A19&"")) Biff "sharder" wrote in message ... I have a list that show mulitple times in my spreedsheet and I need to know how many actual numbers are there Ex: I actually have 5 orders here. 398805 398805 398805 516878 516878 516878 540836 540836 540836 540836 540836 567585 567585 567585 567585 567911 567911 567911 567911 Thanks for your help -- sharder ------------------------------------------------------------------------ sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488 View this thread: http://www.excelforum.com/showthread...hreadid=556605 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count # of unique occurances
Go into Data, go to Filter, go to Advanced Filter. There, you can select
Unique Records Only, and either sort it in place or copy to another location. Bailfire13 "sharder" wrote: I have a list that show mulitple times in my spreedsheet and I need to know how many actual numbers are there Ex: I actually have 5 orders here. 398805 398805 398805 516878 516878 516878 540836 540836 540836 540836 540836 567585 567585 567585 567585 567911 567911 567911 567911 Thanks for your help -- sharder ------------------------------------------------------------------------ sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488 View this thread: http://www.excelforum.com/showthread...hreadid=556605 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count # of unique occurances
Still have to count 'em!
Biff "bailfire13" wrote in message ... Go into Data, go to Filter, go to Advanced Filter. There, you can select Unique Records Only, and either sort it in place or copy to another location. Bailfire13 "sharder" wrote: I have a list that show mulitple times in my spreedsheet and I need to know how many actual numbers are there Ex: I actually have 5 orders here. 398805 398805 398805 516878 516878 516878 540836 540836 540836 540836 540836 567585 567585 567585 567585 567911 567911 567911 567911 Thanks for your help -- sharder ------------------------------------------------------------------------ sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488 View this thread: http://www.excelforum.com/showthread...hreadid=556605 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
| count unique with conditions | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Pivot Table Unique Count | Excel Worksheet Functions | |||
Linear Mode
