Formula - Combine exclusions in a search

[ChrisMac1]

Hi there... I have a formula that I believe is currently returning results from blank cells. Any idea how I get those ignored too in the following formula please?

=MIN(IF(ORGANIC!$AG$2:$AG$100000<>"RESOLVED", ORGANIC!$S$2:$S$100000))

The result needed is the item in column AG (rows 2 to 100000) that has the oldest date shown in column S (rows 2 to 100000), and items called RESOLVED should not be included.

Many thanks,
MAC

 

[Fluff]

How about

=UPPER(TEXT(TAKE(SORT(FILTER(ORGANIC!$S$2:$S$100000,(ORGANIC!$AG$2:$AG$100000<>"RESOLVED")*(ORGANIC!$S$2:$S$100000<>""))),1),"d MMM 'yy"))

 

[ChrisMac1]

How about

=UPPER(TEXT(TAKE(SORT(FILTER(ORGANIC!$S$2:$S$100000,(ORGANIC!$AG$2:$AG$100000<>"RESOLVED")*(ORGANIC!$S$2:$S$100000<>""))),1),"d MMM 'yy"))

Beautiful, thanks so much Fluff!!!

 

[Fluff]

My pleasure.