MAXIMUM VALUE
 

I would like to find the maximum value from a cell (A1) on 40 similar sheets
containing 200 prices in Column A

Example: (using 4 different sheets)
Result Sheet Sales Sheet 1, Col. A Sales Sheet 2, Col. A, Sales Sheet 3
Col. A
1.25
1.36 0.95

Formula would record the value & its associated sheet number for this value.
So the Result Sheet would look like below:
1 A B
2 1.36 Sales Sheet 2
--
Carolan

Hi Carolan,

Use the LARGE() or SMALL() function. Look in HELP for details

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Carolan" wrote in message
...
I would like to find the maximum value from a cell (A1) on 40 similar
sheets
containing 200 prices in Column A

Example: (using 4 different sheets)
Result Sheet Sales Sheet 1, Col. A Sales Sheet 2, Col. A, Sales Sheet 3
Col. A
1.25
1.36 0.95

Formula would record the value & its associated sheet number for this
value.
So the Result Sheet would look like below:
1 A B
2 1.36 Sales Sheet 2
--
Carolan

Sorry, wrong thread!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Niek Otten" wrote in message
...
Hi Carolan,

Use the LARGE() or SMALL() function. Look in HELP for details

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Carolan" wrote in message
...
I would like to find the maximum value from a cell (A1) on 40 similar
sheets
containing 200 prices in Column A

Example: (using 4 different sheets)
Result Sheet Sales Sheet 1, Col. A Sales Sheet 2, Col. A, Sales Sheet
3
Col. A
1.25
1.36 0.95

Formula would record the value & its associated sheet number for this
value.
So the Result Sheet would look like below:
1 A B
2 1.36 Sales Sheet 2
--
Carolan