Hello, ANYONE
Here's my problem
i want to do this: MATCH(<int(now()),$P$3:$P$1048,0)
Now it doesn't work , and I can't find a way of doing it.
I already use a variation on this that works fine but Excel doesn't like the <
Anyone got any ideas?
Hello, ANYONE
Here's my problem
i want to do this: MATCH(<int(now()),$P$3:$P$1048,0)
Now it doesn't work , and I can't find a way of doing it.
I already use a variation on this that works fine but Excel doesn't like the <
Anyone got any ideas?
Can you explain what you want to do. Is the list a list of dates, unsorted?
You want to find the largest date in the past? Try
=MAX(IF(P3:P1048<today(),P3:P1048))
confirmed with CTRL+SHIFT+ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks