Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Can't find formula for largest value in multiple cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
telewats - 09 Jan 2006 14:53 GMT
I'm trying to create a spreadsheet that pulls data from another
spreadsheet in the same file as well as data from other files. In the
attached spreadsheets, I have fields that find the largest value based
on dates entered in multiple cells (ie. In my first spreadsheet, I have
formulas to find the largest date on that page (=largest(xx:xx), and on
my 'master' spreadsheet, I want to find the largest date from the
formulas I just mentioned). The problem I'm finding is that excel won't
let me include more than two cells in my last formula. It tells me I'm
entering too much data. Can someone tell me how to do this?

Signature

telewats

CLR - 09 Jan 2006 15:46 GMT
=LARGE(A1:C50,1)
or
=MAX(A1:C50)

Either formula will return the largest value from the range of A1 through
C50............

Vaya con Dios,
Chuck, CABGx3

> I'm trying to create a spreadsheet that pulls data from another
> spreadsheet in the same file as well as data from other files. In the
[quoted text clipped - 5 lines]
> let me include more than two cells in my last formula. It tells me I'm
> entering too much data. Can someone tell me how to do this?
telewats - 09 Jan 2006 17:20 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.