I have a data set similar to below

Date Field 1 Field 2 Field 3
1/1/09 x x o
1/5/09 o x x
1/14/09 o o x

I also have an array formula in a separate cell that looks for the row with
the closest match to today's date and is supposed to return the row number
that is the closest match. The formula is:
=MATCH(MIN(ABS($A:$A-TODAY())),ABS($A:$A-TODAY()),0)

But now I receive a new error: #NUM!

All of the dates only live in Column A. I am not sure what I'm doing wrong.

Any help would greatly be appreciated.

Thanks for your time and effort.

Try removing the reference to the entire column, just use a range big
enough for your needs:

=MATCH(MIN(ABS($A1:$A20000-TODAY())),ABS($A1:$A20000-TODAY()),0)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54908