Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Betternotpeak
 
Posts: n/a
Default Excel:a column of numbers,I want the highest shown automatically?

Can a conditional formula study a column of numbers and enter the highest or
lowest in the result cell? If yes how do you do it?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default Excel:a column of numbers,I want the highest shown automatically?

Hi

?
=MAX(A:A)
=MIN(A:A)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Betternotpeak" wrote in message
...
Can a conditional formula study a column of numbers and enter the highest
or
lowest in the result cell? If yes how do you do it?



  #3   Report Post  
Posted to microsoft.public.excel.misc
Betternotpeak
 
Posts: n/a
Default Excel:a column of numbers,I want the highest shown automatical

thanks

"Arvi Laanemets" wrote:

Hi

?
=MAX(A:A)
=MIN(A:A)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Betternotpeak" wrote in message
...
Can a conditional formula study a column of numbers and enter the highest
or
lowest in the result cell? If yes how do you do it?




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
IF/AND/OR/DATEIF Issue...sorry...long post... EDSTAFF Excel Worksheet Functions 1 November 10th 05 12:28 AM
How to change column letters to correct ones in many formulas automatically? Dmitry Kopnichev Links and Linking in Excel 7 October 13th 05 09:52 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 11:35 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"