LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default ARRAY - Counting Games Played

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
seeking template to track tokens played in arcade game and payout arcademanager Setting up and Configuration of Excel 3 June 23rd 08 11:29 AM
Counting in an array PAL Excel Worksheet Functions 5 October 29th 07 08:34 PM
Array: Counting multiple values within array Trilux_nogo Excel Worksheet Functions 4 April 16th 07 03:12 AM
ARRAY NOT COUNTING A CERTAIN ROW Rafterrpf Excel Worksheet Functions 2 April 15th 07 01:46 PM
I played with my windows theme, now I can't see Excel cell format grndplane Excel Discussion (Misc queries) 5 February 9th 07 07:24 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"