auto sort cells
 

HELLO
I have table with dates in cells C3:C33
I wont after I write her dates come out automatically the 6 bigger
dates in the column L
(L3=the 1st date, L4=the 2nd date etc).

auto sort cells
 

You can use the LARGE function

Cell L3 Formula = LARGE($C$3:$C$33,1) formatted as a date
Cell L4 Formula = LARGE($C$3:$C$33,2) formatted as a date
Cell L5 Formula = LARGE($C$3:$C$33,3) formatted as a date
Cell L6 Formula = LARGE($C$3:$C$33,4) formatted as a date
Cell L7 Formula = LARGE($C$3:$C$33,5) formatted as a date
Cell L8 Formula = LARGE($C$3:$C$33,6) formatted as a date



billll Wrote:
HELLO
I have table with dates in cells C3:C33
I wont after I write her dates come out automatically the 6 bigger
dates in the column L
(L3=the 1st date, L4=the 2nd date etc)

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=56765