Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
telewats
 
Posts: n/a
Default Can't find formula for largest value in multiple cells


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?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387

  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Can't find formula for largest value in multiple cells

=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




"telewats" wrote:


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?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387


  #3   Report Post  
Posted to microsoft.public.excel.newusers
telewats
 
Posts: n/a
Default Can't find formula for largest value in multiple cells


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
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387

  #4   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Can't find formula for largest value in multiple cells

=MAX(B12,B40,B65)
=MAX(Sheet1!B12,Sheet2!B40,Sheet3!B65)

Vaya con Dios,
Chuck, CABGx3


"telewats" wrote:


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
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387


  #5   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme
 
Posts: n/a
Default Can't find formula for largest value in multiple cells

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"telewats" wrote in
message ...

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
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387





  #6   Report Post  
Posted to microsoft.public.excel.newusers
telewats
 
Posts: n/a
Default Can't find formula for largest value in multiple cells


This worked great - thanks!


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the Formula to find the Media of a number of cells? formula to find the media between cells Excel Worksheet Functions 2 December 19th 05 05:35 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
How to copy and paste same formula in multiple cells? Amanda Excel Worksheet Functions 1 June 30th 05 04:16 PM
apply a formula to multiple cells FixitFrog Excel Discussion (Misc queries) 3 June 23rd 05 11:54 AM
Find and delete part of formula for multiple formulas? coal_miner Excel Worksheet Functions 1 June 17th 05 05:41 PM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"