M
markx
Hello,
I have two columns: "Starting date" (A) and "Ending date" (B) with values in
more than 100 rows.
In addition, I have current date in D1 cell.
I want to run on the A column a conditional MIN() function and do the
following:
Find MIN in column A, but excluding (from the calculation) the rows where
the value in B column (ending date) is smaller than the current date
(specified in D1 cell).
If D1 = 01 May 2006
and the rows are:
column A column B
1 Jan 02 1 Dec 2005
1 Mar 03 1 Jan 2006
1 Dec 03 1 Mar 2008
1 Apr 05 1 Aug 2007
then the normal MIN(A:A) would give me 1 Jan 02
However, I'm looking for 1 Dec 03 (=the smallest value in column A among the
rows where the value in column B is equal or bigger than D1).
Could you give me some hints how to achieve this?
Many thanks for your help!
Mark
I have two columns: "Starting date" (A) and "Ending date" (B) with values in
more than 100 rows.
In addition, I have current date in D1 cell.
I want to run on the A column a conditional MIN() function and do the
following:
Find MIN in column A, but excluding (from the calculation) the rows where
the value in B column (ending date) is smaller than the current date
(specified in D1 cell).
If D1 = 01 May 2006
and the rows are:
column A column B
1 Jan 02 1 Dec 2005
1 Mar 03 1 Jan 2006
1 Dec 03 1 Mar 2008
1 Apr 05 1 Aug 2007
then the normal MIN(A:A) would give me 1 Jan 02
However, I'm looking for 1 Dec 03 (=the smallest value in column A among the
rows where the value in column B is equal or bigger than D1).
Could you give me some hints how to achieve this?
Many thanks for your help!
Mark