MIN after date

**skipro** · 07-18-2018, 11:41 PM

A:A -list of dates in order
I:I text and numbers

I need to get the MIN of I:I after the date, 8/31/2017 or A9

=Min(IF(A:A,">"&Date(2017,7,31),I:I))
=Min(IF(A:A,>A9),I:I))
These do not work.

I do not want to use a row range, =MIN(A10:Axx).

=Min(I:I)
This works, but includes dates before 8/31/2017.

**FDibbins** · 07-18-2018, 11:49 PM

A:A -list of dates in order
I:I text and numbers

1. Are you sure they are dates, and not text looking like dates?
2. try this...
=Min(IF(A:A,">7/31/2017",I:I))

When all else fails, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**Phuocam** · 07-19-2018, 01:37 AM

Try:

=MIN(IF(A:A>DATE(2017,7,31),I:I))

Or:

=MIN(IF(A:A>A9,I:I))

Enter with Ctrl+Shift+Enter.

**skipro** · 07-19-2018, 03:55 PM

Thanks FDibbins & Phuocam for responding.
FDibbins,
Returns number before 7/31/17.
Phoucam,
Both work in a sample I made, but it does not work in my spreadsheet. I assume something in sheet is conflicting.

Is there a formula that would return for the second "MIN", or the next larger number from "MIN", since there is only 1 number before 7/31/17 and this should be the smallest number?
In other words, is there a way to ignore the minimum amount, but return the next larger number or the second minimum number?