N
New Hope UMC
I received help on this earlier and the solution did not work, 'cause
I did not explain it well enough. So here we go...
Sheet "Team Breakout"
Cell D:27 is the company name
Column C Column D
Cell C:35 "A" All Teams achieving an "A" score
Cell C:36 "B" All Teams achieving an "B" score
Cell C:37 "C" All Teams achieving an "C" score
Cell C:38 "D" All Teams achieving an "D" score
Cell C:39 "F" All Teams achieving an "D" score
The above represents the layout I need.
The actual data this comes from is as follows:
Sheet "CrewData"
Column A Column B Column C
Company Name "Team" The score
What I need is this:
Cell D35; give me all of the teams achieving an "A" score (which is
represented ">=90%, <=100%") by looking in the at column A (matching
the Company Name in Cell D:27) and column C matching the ">=90%,
<=100%" Score. Cell D35 could then contain up to 85 different numbers
Then repeat the process for B,C,D and F scores appropriately.
Any clues?
I did not explain it well enough. So here we go...
Sheet "Team Breakout"
Cell D:27 is the company name
Column C Column D
Cell C:35 "A" All Teams achieving an "A" score
Cell C:36 "B" All Teams achieving an "B" score
Cell C:37 "C" All Teams achieving an "C" score
Cell C:38 "D" All Teams achieving an "D" score
Cell C:39 "F" All Teams achieving an "D" score
The above represents the layout I need.
The actual data this comes from is as follows:
Sheet "CrewData"
Column A Column B Column C
Company Name "Team" The score
What I need is this:
Cell D35; give me all of the teams achieving an "A" score (which is
represented ">=90%, <=100%") by looking in the at column A (matching
the Company Name in Cell D:27) and column C matching the ">=90%,
<=100%" Score. Cell D35 could then contain up to 85 different numbers
Then repeat the process for B,C,D and F scores appropriately.
Any clues?