Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Different Names in A Column... Formula?
Just wanted to know if there is a Formula that can count DIFFERENT names in a Column? eg. There may be more than 1 same name, but I dont want it counted twice: James Edward Max John David James James Lisa Total should = 6 (Since James is 1 person) Is there a formula to solve this type of count? Thanks for any help on this.. -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980 View this thread: http://www.excelforum.com/showthread...hreadid=571093 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Different Names in A Column... Formula?
Try this For a list of names (with possible multiples) in A1:A10 This formula returns the count of unique items: B1: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=571093 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting Different Names in A Column... Formula?
Yes Ron, That Solved My Question... The Unique Factor..:) Thank You Very Much! -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980 View this thread: http://www.excelforum.com/showthread...hreadid=571093 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a formul | Excel Discussion (Misc queries) | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) |