ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel:a column of numbers,I want the highest shown automatically? (https://www.excelbanter.com/excel-discussion-misc-queries/63219-excel-column-numbers-i-want-highest-shown-automatically.html)

Betternotpeak

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?

Arvi Laanemets

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?




Betternotpeak

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?






All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com