LinkBack URL
About LinkBacksHELLO
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).
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).
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
Originally Posted by billll
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks