Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
Hello Can someone help me? I want to make an excel table for a tournament i'm organizing. the function which i'd like to know is the following: in each column, i'd have the names of the players that have scored goals (each column would be one match). So I'd like to know a formula that would count how many times each player appears and give me a list of all of them. Was I clear? If not, please ask and I'll try to explain again. Thanks in advance -- são paulo ------------------------------------------------------------------------ são paulo's Profile: http://www.excelforum.com/member.php...o&userid=34468 View this thread: http://www.excelforum.com/showthread...hreadid=542284 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting
How about this in B1 enter the name you want to count enter this function in C1 or wherever this is just an example of how to count =COUNTIF(A1:A9,B1) A1:A9 is the range of names B1 is the criteria -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=542284 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif counting properties | Excel Discussion (Misc queries) | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |