M
Mike Psarras
I have this problem. I have created a workbook with many
worksheets. Every worksheet has different values but they
are located on the same cells in every worksheet. When I
need to find the max or min of a value I have no problem.
I write i.e. max(worksheet1:worksheet30!A3) and I get the
max value of the content of cell A3. My great problem is
when I want to locate the worksheet where the max value
of cell A3 is. I found a way by using the find&replace
but it is not so fast and accurate. Can you please tell
me how can I find in which worksheet the min or max value
is ??? Maybe using vlookup or hlookup or match... I
really don't know. Please reply I desperate..
worksheets. Every worksheet has different values but they
are located on the same cells in every worksheet. When I
need to find the max or min of a value I have no problem.
I write i.e. max(worksheet1:worksheet30!A3) and I get the
max value of the content of cell A3. My great problem is
when I want to locate the worksheet where the max value
of cell A3 is. I found a way by using the find&replace
but it is not so fast and accurate. Can you please tell
me how can I find in which worksheet the min or max value
is ??? Maybe using vlookup or hlookup or match... I
really don't know. Please reply I desperate..