Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to calculate how many games a player named "Arenas" has played
based on data in two worksheets, "Source" and "Chart1." In Source, the entries in col A are as follows: COL A Arenas Butler Haywood Thomas Stevenson Brown Smith In Chart1 the entries in cols A and E are as follows. COL A COL E 4/23/08 Arenas 4/24/08 Butler 4/24/08 Arenas 4/23/08 Haywood 4/23/08 Arenas 4/26/08 Thomas 4/26/08 Thomas 4/26/08 Arenas 4/26/08 Arenas Each unique player and date combination counts as 1 game played. In this example, it is evident from the data in Chart1 that Arenas has played in 3 games (4/23, 4/24, 4/26) even though his name is listed 5 times, two of which are for games on the same dates (4/23 and 4/26). From the Source sheet, I want a formula that will calculate this example, keeping in mind that the rows of data are actually 1 to 20000 Can anyone help? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
seeking template to track tokens played in arcade game and payout | Setting up and Configuration of Excel | |||
Counting in an array | Excel Worksheet Functions | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
ARRAY NOT COUNTING A CERTAIN ROW | Excel Worksheet Functions | |||
I played with my windows theme, now I can't see Excel cell format | Excel Discussion (Misc queries) |