Hi,
I have a spreadsheet including two columns - 'date replied' and 'date completed'. For each row of data, only one column will contain a date, and the other will read 'None'.
Eg:
Capture.JPG
I want to combine both columns into one e.g. 'date actioned', where is uses the date which is present, and ignores the 'None' values.
Is there a formula I can use that will achieve this?
Many thanks,
Emma
Try
E2=IF(ISNUMBER(C2),C2,IF(ISNUMBER(D2),D2,"")) and drag down.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Try
=MAX(C2:D2)
To cater for blanks ..
=IF(COUNT(C2:D2),MAX(C2:D2),"")
Last edited by JohnTopley; 05-17-2016 at 07:49 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks