200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have a file where I ahve a filtered Column D and I select an Item from Column D. A few visible rows appear based on that selection. Now there are two date columns ( A & B) where A is Start Date & B is End Date.
I need to check whether the second visible row's End Date (Col B) is less than first row's End Date. If Yes, corresponding cell of Column C must have 'Yes' printed else 'No'
Can anyone help urgently please?
=IF(A1<B1,"Yes","No")
Try that.
You may need to copy the filtered list to a different column....reason being that the filtered list MAY hide rows. Once this is done, formula very much like Don's =IF(B2>B3,"LessThan","")....If the first row is header and the 2nd row contains the first date, you will have to put this in the row below that (Example Header in Row 1, 1st date in row 2, then copy formula above to row 3)
