Hi - I am trying to find a way to bring over data using dates. Can I use a
look up to say 'if you find any date in "cell a"? So far as I can see lookups
and if statements can not be applied to cover any date reference - you have
to specify a particular date.
I currently use a spreadsheet which is updated with the date whenever I
receive either text or images I am waiting for. If nothing has been received
then nothing is put into cell and it remains blank. I need to create a way
for me to quickly look through all the data and return a list of items which
have not been received (hence no date in cell). Can anyone think of a better
way to do this?
Thanks