Please help…
Please see attached -
I need Column G to equal the most recent date that appears in columns A, C and E. If A, C or E are blank G needs to be blank as well. C and/or E could have a value of N/A. The problem seems to occur when more than one of A, C or E contains the value of N/A (such as rows 8, 9 and 10).
in G2
=IF(MAX(A2,IF(C2="N/A",0,C2)=0,IF(E2="N/A",0,E2))=0,"",MAX(A2,IF(C2="N/A",0,C2)=0,IF(E2="N/A",0,E2)))
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Try this in G2, entered as an array formula with CTRL+SHIFT+ENTER
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Doesn't work for row 6Originally Posted by Olly
Try:
Formula:Please Login or Register to view this content.
UPDATE: Oops! Yes it does! It's mine that doesn't :-)
Yup, as per requirement:
Many thanks all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks