- Hot Topics
Excel Count - index - match problem
Hey Chaps I am basically trying to retrieve a date in column F with specific conditions. Basically I want to get the result (DATE) from after the DATE in cell E6 and E7. E.g Therefore CELL F6 should show 03/12/2012 because CELL E6 has the date of 26/11/2012 (<--- Hence M5[Date] Onwards). And F6 should show 06/11/2012 but instead shows 01/11/2012. My current formula pulls the very first date but what I want is the value/date onwards from cell E6-E7. REALLY SORRY ABOUT THE PICTURE ... I can't install HTML Genie at work so had to upload a photo! [IMG]Image and video hosting by TinyPic[/IMG] Again! SUPER APPRECIATIVE FOR ANY HELP OR GUIDANCE! Will donate to charity for your choice for your help! Kind regards Syed from England Last edited by syedbokhari; Apr 2nd, 2014 at 08:46 AM.
This question generated 24 answers. To proceed to the answers, click here.
This thread is current as of April 2, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel