| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to Auto sort or save a sort? | Excel Discussion (Misc queries) | |||
| Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
| auto sort | Excel Worksheet Functions | |||
| Auto sort | Excel Programming | |||
| Auto Sort | Excel Worksheet Functions | |||
Linear Mode
