|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com