Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solver- maximum profit | Excel Worksheet Functions | |||
Scroll Bar maximum value | Charts and Charting in Excel | |||
Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
What is the maximum text size in a cell | Excel Discussion (Misc queries) | |||
Cell value as chart scale maximum | Charts and Charting in Excel |