Array Formula Error
 

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.

Array Formula Error
 

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