| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New excel user question: Incase of tie, select latest date
This will probably be really simple for most of you. This is coming from someone really new to excel. I'm working on a worksheet and I can't figure out how to do this. In case of a tie, select the latest date. And it says i can't use the sort command. Now i can figure out how to tell if there is a tie using =IF(COUNTIF(I13:I43,MIN(I13:I43))=2,"Tie","no tie") But i can't figure out how to tell it to show the latest date. Thanks for any input or hints on what to experiment with. -- liptonbnl ------------------------------------------------------------------------ liptonbnl's Profile: http://www.excelforum.com/member.php...o&userid=35282 View this thread: http://www.excelforum.com/showthread...hreadid=550664 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| QUESTION: Copy pivottable from excel file to another. | Excel Discussion (Misc queries) | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| How too set last edited date in excel and which user was it? | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Threaded Mode
