lowest Digit Cell...

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

Pivotrend

hello

what's the formula to use when i have 20 cells with digits
& i want to get the lowest digit on those 20 cells, in a different cell
?
 
i ment like If

A1 is 8.02
A2 is 8.24
A3 is 9.79
A4 is 7.09
A5 is 7.15


& Cell C1 suppose to Show 7.09
 
=SMALL(A1:A20,1)

or

=MIN(A1:A20)



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
thanx guys that did it
i need some information too
how can i make C2 show me the result adjacent to the lowest vales cell
?

like C1=min(A1:A5)
A1 is 8.02
A2 is 8.24
A3 is 9.79
A4 is 7.09
A5 is 7.15

C1 will give me 7.09 which is A4
now i need the information in B4 to show up in C2

information between A1:A5 is subject to change
Results in B Cells also change with them
 
Back
Top