Hi Everyone
I hope you can help - Im trying to figure the correct formula and being a slight Excel obsessive with basic formula understanding, im in a pickle!
I want my master Cell (in column N) to write a status based on the entry of a date (any date) of column G to read "Await Collect"
BUT
If column H has a date (any date, always greater than the date in Column F) I want it to read "Gone"
Ive really tried searching under IF with ANY or OR in the argument but my head is mashed.
Your expertise and advice is very much appreciated.
Bookmarks