#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Largest number

Use your name <s.

=MAX(C1:C4)

HTH
Kostis Vezerides

On Apr 29, 7:09*pm, MAX wrote:
I have a range of cells with a number in each cell (below).
Cell C1 *24
Cell C2 *12
Cell C3 *14
Cell C4 *7

I want a formula that gets the largest number in Cell B1.

Thanks.


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
Largest Prime Number Gary''s Student Excel Discussion (Misc queries) 10 November 24th 08 01:26 AM
Finding the largest number help John Excel Discussion (Misc queries) 7 October 23rd 07 11:10 PM
highlight largest number in a row snmcpa Excel Worksheet Functions 2 July 17th 06 07:50 PM
finding the largest number from the last row and look up its name. Jeff Excel Worksheet Functions 5 February 24th 05 10:40 PM
How do I sum 4 number discarding the largest number. SteveP Excel Worksheet Functions 3 December 22nd 04 02:25 PM


All times are GMT +1. The time now is 10:24 PM.

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

About Us

"It's about Microsoft Excel"