A few options, one would be:
=IF(COUNTIF(I21:I23,">0"),SMALL(I21:I23,COUNTIF(I21:I23,"<=0")+1),0)
A few options, one would be:
=IF(COUNTIF(I21:I23,">0"),SMALL(I21:I23,COUNTIF(I21:I23,"<=0")+1),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks