Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with possible formula
I need to find the count of a list of numbers listed in a column(specific). But where the number exists more than once I need it to be counted only once. In the example below this formula should return 4 as the answer. Thanks in advance. Example: Column B 23789 24567 23789 14578 09075 23789 -- Michael Wise ------------------------------------------------------------------------ Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 View this thread: http://www.excelforum.com/showthread...hreadid=541534 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with possible formula
Hi Michael, Have a look at Chip's page: http://www.cpearson.com/excel/duplic...CountingUnique hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=541534 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with possible formula
On Fri, 12 May 2006 08:00:48 -0500, Michael Wise
wrote: I need to find the count of a list of numbers listed in a column(specific). But where the number exists more than once I need it to be counted only once. In the example below this formula should return 4 as the answer. Thanks in advance. Example: Column B 23789 24567 23789 14578 09075 23789 One way: =SUMPRODUCT((B1:B6<"")/COUNTIF(B1:B6,B1:B6&"")) HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with possible formula
Hi Michael,
Look he http://www.cpearson.com/excel/duplic...CountingUnique -- Kind regards, Niek Otten "Michael Wise" wrote in message news:Michael.Wise.27p4am_1147439407.1873@excelforu m-nospam.com... | | I need to find the count of a list of numbers listed in a | column(specific). But where the number exists more than once I need it | to be counted only once. In the example below this formula should | return 4 as the answer. Thanks in advance. | | Example: | | Column B | 23789 | 24567 | 23789 | 14578 | 09075 | 23789 | | | -- | Michael Wise | ------------------------------------------------------------------------ | Michael Wise's Profile: http://www.excelforum.com/member.php...fo&userid=6998 | View this thread: http://www.excelforum.com/showthread...hreadid=541534 | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with possible formula
Hi Michael, Have a look at Chip's page: http://www.cpearson.com/excel/duplic...CountingUnique hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=541534 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |