JKB
12-04-2015, 06:34 AM
Hi guys!
First of all i would like to say, i first searched on google "Match can't find date" and it came up with some very different results than what i was looking for.
That being said, does anybody know what could be wrong, if i have a series of dates, i copy a specific date as value into an empty cell. Then i search for the pasted value in "Find", which as far as i know is the same the match function does, but i cant find it??? In short, i have just copied a cell, then i search for it, and it cant find any other identical value... Have anybody tried this? How did you solve it?
Cheers!!!
First of all i would like to say, i first searched on google "Match can't find date" and it came up with some very different results than what i was looking for.
That being said, does anybody know what could be wrong, if i have a series of dates, i copy a specific date as value into an empty cell. Then i search for the pasted value in "Find", which as far as i know is the same the match function does, but i cant find it??? In short, i have just copied a cell, then i search for it, and it cant find any other identical value... Have anybody tried this? How did you solve it?
Cheers!!!