Hi All,
I am trying to automate a spreadsheet that tells me when an item had an action taken out on it, and when in the future the next action is due on it.
this data is ran from a database system, which I extract and pop into a spread sheet which collates what I need. But when no data appears on the Data, my formula brings that back as a default date (00/00/1900), which makes it all hard to work out.
Is there something I can add to my formula, or is there another formula that would take out the default date and leave as a blank?
I have used the following formula:
Index(raw data!A:A,match(raw data!G:G,Ouput!A:A,false),1)
I have attached a dummy example for you to play with.
Looking forward to your fantastic as always responses.
Cheers
Donna
Bookmarks