Okay, this is a challenge to all of you excel wizards out there. If
you can figure this out, well, I'll be impressed. Here it is:

The first worksheet in my workbook I have the master information that I
am collecting (I called this worksheet "Master"). This information has
two columns, one is alpha and the other numeric. Also in this
worksheet I add up the number of "correct answers" for each worksheet
(lets call them two, three, four, etc.) and give a point for each
correct answer for each problem. Column D is worksheet two's score for
the problem, Column E is worksheet three's score for the problem, and
so on. A correct answer is worth one point, all others are worth zero.

Row 1 is problem 1, Row 2 is problem 2, and so on. Lets say in column
A is my alpha column. In cell A1 I have the word "Sell". Column B is
my numeric column. In cell B1 I have the value "20".

In a worksheet two, A1 reads "Buy" and B1 reads "10".
In worksheet three, A1 reads "Sell" and B1 reads "22".
In worksheet four, A1 reads "Sell" and B1 reads "10".

Because worksheet four gave the correct alpha value AND had the closest
numeric value (without going over) it should be provided a point for
providing the correct answer for problem 1. This means the value for
cell F1 in the master worksheet should reflec this and read "1".
Alright, does anyone have any idea?

wrote...
....
Row 1 is problem 1, Row 2 is problem 2, and so on. Lets say in column
A is my alpha column. In cell A1 I have the word "Sell". Column B is
my numeric column. In cell B1 I have the value "20".

In a worksheet two, A1 reads "Buy" and B1 reads "10".
In worksheet three, A1 reads "Sell" and B1 reads "22".
In worksheet four, A1 reads "Sell" and B1 reads "10".

Because worksheet four gave the correct alpha value AND had the closest
numeric value (without going over) it should be provided a point for
providing the correct answer for problem 1. This means the value for
cell F1 in the master worksheet should reflec this and read "1".
Alright, does anyone have any idea?

Presumably the target sell price is the highest price obtainable, so
setting a sell price above it would result in never selling, which
would be a good reason to tossing sell prices above the target. If the
answer were Buy, on the other hand, presumably the price would never go
lower than than the target buy price, so any answers with buy prices
below the target would also never be realized, so when the correct
answer is Buy, you'd only want to consider answers with prices
*greater* than or equal to the target buy price.

Presumably if multiple other worksheets have the same best answer, both
worksheets would get a point.

You'll need a list of all the answer worksheet names in some range or
array. I'll assume its named AWSLst.

If all worksheets have alpha an numeric answers also in columns A and
B, respectively, then in the master workbook,

D1:
=AND(Two!$A1="Sell",Two!$B1=MAX(IF(N(INDIRECT("'"& AWSLst&"'!"
&CELL("Address",$B1)))<=$B1,N(INDIRECT("'"&AWSLst& "'!"
&CELL("Address",$B1))))))+(Two!$A1="Buy",Two!$B1=M IN(IF(N(INDIRECT("'"&
AWSLst&&"'!"&CELL("Address",$B1)))=$B1,N(INDIRECT ("'"&AWSLst&"'!"
&CELL("Address",$B1))))))

Fill D1 right as needed and replace Two with Three in E1, Two with Four
in F1, Two with Five in G1, etc.

Wow, that looks nuts!!! Does this consider the values of the other
worksheets as well as the master? I put it in to my workbook, but
nothing happened :( I really appreciate your effort though.

wrote...
Wow, that looks nuts!!! Does this consider the values of the other
worksheets as well as the master? I put it in to my workbook, but
nothing happened :( I really appreciate your effort though.

OK, I screwed up the formula in a few places. It should be

D1 [array formula]:
=AND(Two!$A1="Sell",
Two!$B1=MAX(IF(N(INDIRECT("'"&AWSLst&"'!"&CELL("Ad dress",$B1)))<=$B1,
N(INDIRECT("'"&AWSLst&"'!"&CELL("Address",$B1))))) )
+AND(Two!$A1="Buy",
Two!$B1=MIN(IF(N(INDIRECT("'"&AWSLst&"'!"&CELL("Ad dress",$B1)))=$B1,
N(INDIRECT("'"&AWSLst&"'!"&CELL("Address",$B1))))) )

Note: *YOU* must create a list of the other worksheet names, either as
an array or range named AWSLst. The formula won't do anything useful if
you don't.

Great thanks for your help... I am not sure I'll be able to get this to
work, but I really appreciate your time and effort!