Find the smallest number in a filtered dataset

[humanoid769]

Hi I currently use =MIN(IF(N5:N6606>0,N5:N6606)) which finds the smallest positive number in a sheet, ho can I modify this to find the smallest positive number in a filtered list? for example if I filtered the data to only show me data from today I want to find the smallest number from the results

Thanks
Tony

 

[CA_Punit]

But then i suppose you have date criteria also, which you have ignored

 

[CA_Punit]

You have to set the date criteria also in Minifs function or filter function as stated by Peter_Sss in post 4

Change the Today to a list of dates which is required

 

[Peter_SSs]

Try

=AGGREGATE(15,6,N5:N6606/((SUBTOTAL(102,OFFSET(N5,SEQUENCE(ROWS(N5:N6606),,0),,1)))*(N5:N6606>0)),1)

 

[humanoid769]

Try

=AGGREGATE(15,6,N5:N6606/((SUBTOTAL(102,OFFSET(N5,SEQUENCE(ROWS(N5:N6606),,0),,1)))*(N5:N6606>0)),1)

Thankyou Thankyou Thankyou exactly what I wanted

Tony

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.