This is good to know. Thanks for the info.
What if I want to use cells that aren't in conjunction with one
another, ie. B12 & B40 & B65? Or if I want to pull data from multiple
spreadsheets?

Signature
telewats
CLR - 09 Jan 2006 17:50 GMT
=MAX(B12,B40,B65)
=MAX(Sheet1!B12,Sheet2!B40,Sheet3!B65)
Vaya con Dios,
Chuck, CABGx3
> This is good to know. Thanks for the info.
>
> What if I want to use cells that aren't in conjunction with one
> another, ie. B12 & B40 & B65? Or if I want to pull data from multiple
> spreadsheets?
Bernard Liengme - 09 Jan 2006 19:21 GMT
Click on B12; hold CTRL, click on B40 then on B65; type mydata in Name box
and pres ENTER
Use =MAX(mydata) or LARGE(mydata,1) ---- you can also use LARGE(mydata,2)
for next largest
Multiple sheets: MAX(MAX(Sheet1!A1:A10), MAX(Sheet2!B2:B20)
Or expand on the name method
best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> This is good to know. Thanks for the info.
>
> What if I want to use cells that aren't in conjunction with one
> another, ie. B12 & B40 & B65? Or if I want to pull data from multiple
> spreadsheets?
telewats - 09 Jan 2006 19:26 GMT
This worked great - thanks!

Signature
telewats