Create a Report in Excel

[XLXLXL]

I am in the exploratory stages of determining whether I can create a report in Excel 2007 to add the instances of a particular entry in a column. It is tricky, because I want to survey only the first 4 entry rows of a group of 8 entries and then return the result as only one instance of the entry over each of a set number of these sets of data rows, in each case 4 sets. This process would repeat down the spreadsheet, and the number of occurrences of each particular entry summed and reported in a separate tab of the same spreadsheet.

The rows in this spreadsheet are 17-1240. The entry names are a combination of two columns, J and K. These must match identically for the counter to count an additional entry.

I am really a total novice at this, but I do know that I would prefer to make the report in a different tab in the same spreadsheet...just available for reference.

All I would really like to know is...is this possible in Excel 2007?

 

[alansidman]

Are you able to show some examples of what you have and what you want. You can post sections of your worksheet using Excel Jeannie which is available for download on this site. Or you can use Richard Schollar's program which is also available on this site.

http://www.mrexcel.com/forum/showthread.php?t=515787

It is tough to visualize what you are asking for.

Alan

 

[XLXLXL]

Thanks Alan. Not sure if this is it or not but

Excel Workbook
	E	F	G	H	I	J	K
21					Group A Bench	Ernie	Els
22					Group B Bench	DQ
23					Group B Bench	Ian	Poulter
24					Group C Bench	Anthony	Kim
25		Round	2	2	Group A	Dustin	Johnson
26					Group B1	Steve	Stricker
27					Group B2	Stuart	Appleby
28					Group C	Anthony	Kim
29					Group A Bench	Ernie	Els
30					Group B Bench	Ian	Poulter
31					Group B Bench	DQ
32					Group C Bench	Jason	Day
33		Round	3	3	Group A	Dustin	Johnson
34					Group B1	Steve	Stricker
35					Group B2	Ian	Poulter
36					Group C	Anthony	Kim
37					Group A Bench	Ernie	Els
38					Group B Bench	Stuart	Appleby
39					Group B Bench	DQ
40					Group C Bench	Jason	Day
41		Round	4	4	Group A	Dustin	Johnson
42					Group B1	Steve	Stricker
43					Group B2	Ian	Poulter
44					Group C	Anthony	Kim
45					Group A Bench	Ernie	Els
46					Group B Bench	Stuart	Appleby
47					Group B Bench	DQ
48					Group C Bench	Jason	Day
49	2	Round	1	5	Group A	Jim	Furyk
50					Group B1	Robert	Allenby
All In One Roster Data

Excel 2007

I could only get 30 lines, so the first four lines of week one/round one (from the first set of 8) aren't shown. Column E signifies when a new set of 4 sets of 8 entries begins. I want to take the instances of the first 4 entries (Columns J + K) of each of these sets of 8 entries and calculate the number of times an entry appears once or more times (reported as one time for summing, so, if an entry appears any number of times (1-4) in the 4 sets of the first 4 of 8 entries, it is reported (counted) as a "1" for summing) in the set of four sets, then sum them for each instance down the spreadsheet and create a report...

Basically, no matter how many times an entry appears in the first four of the eight for each round, it is recorded as a "1" for the summing process for the report.

There is a glitch in week 3, which has 5 rounds. I figure if I can get this done, then I can make the tweak later. Again the rows are 17-1240...

 

[XLXLXL]

Sorry, this...

Basically, no matter how many times an entry appears in the first four of the eight for each round, it is recorded as a "1" for the summing process for the report.

should read

Basically, no matter how many times within a set of 4 rounds an entry appears in the first four of the eight entries for each round, it is recorded as a "1" for the summing process for the report...