Array formula (validate with Ctrl+Shift+Enter) :
I have a date range, containing blanks and values. I need a function to show the earliest date that contains a non-blank value. The function should be robust enough that I can sort by date and still show the correct data.
Example...(correct answer would be 10/26/2006)
Date ... Value
Last edited by effang; April 26th, 2008 at 08:00.
awesome, looks good. what if the data range is constantly influx? I tried using the entire column, EG (b:b,."",12) but that didn't seem to work.
It probably has to do with the fact that as the date column grows larger and larger, you will encounter blanks as well, which would naturally return a min of 0. Seems like an easy way is to tie out an if function, to return the row # where both date and data return 0, and plug that into the array...not sure.
If there are blank cells in column A, use the array formula :
Moreover, you can't use entire rows or columns in array formula. You may use A1:A65535, but not A:A.
There are currently 1 users browsing this thread. (0 members and 1 guests)