Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column of Text Shown = Total Times Shown?
Hello All, I am not too sure how to explain it so I will provide an example. Column C represents how many times that name was shown. Is there an easy way to do this or a simple formula? I appreciate the help A B C Phil Phil 3 Phil Bob 2 Phil Anne 4 Bob John 2 Bob Anne Anne Anne Anne John John Peace Phil C. -- philcassell ------------------------------------------------------------------------ philcassell's Profile: http://www.excelforum.com/member.php...o&userid=36520 View this thread: http://www.excelforum.com/showthread...hreadid=562737 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column of Text Shown = Total Times Shown?
I take it Col A is a list of names, Col is the name you wish to count and Col C is your Formula cell. If so add any of these formula's to C1 =SUMPRODUCT(--($A$1:$A$11=B1)) or =COUNTIF($A$1:$A$11,B1) Below is an array (Enter with Ctrl + Alt + Enter) just for info =SUM(IF($A$1:$A$11=B1,1,0)) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562737 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column of Text Shown = Total Times Shown?
Column C represents how many times that name was shown. Is there an
easy way to do this or a simple formula? With the list of unique names listed in B1 down In C1, copied down: =COUNTIF(A:A,B1) will return the indicated counts .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "philcassell" wrote: Hello All, I am not too sure how to explain it so I will provide an example. Column C represents how many times that name was shown. Is there an easy way to do this or a simple formula? I appreciate the help A B C Phil Phil 3 Phil Bob 2 Phil Anne 4 Bob John 2 Bob Anne Anne Anne Anne John John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column of Text Shown = Total Times Shown?
You rock!!!, that is exactly what I was looking for!!! Thanks!!!!! VBA Noob Wrote: I take it Col A is a list of names, Col is the name you wish to count and Col C is your Formula cell. If so add any of these formula's to C1 =SUMPRODUCT(--($A$1:$A$11=B1)) or =COUNTIF($A$1:$A$11,B1) Below is an array (Enter with Ctrl + Alt + Enter) just for info =SUM(IF($A$1:$A$11=B1,1,0)) VBA Noob -- philcassell ------------------------------------------------------------------------ philcassell's Profile: http://www.excelforum.com/member.php...o&userid=36520 View this thread: http://www.excelforum.com/showthread...hreadid=562737 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
parsing text in a multiple column count | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |