I have a column of numbers and a few of them have #NA in them and I need to find the smallest number in the column. The next cell looks to see if there is more that one of that number.
=SMALL(B163:B238,COUNTIF(B163:B238,0)+COUNTIF(B163:B238,"<0")+1) This is the formula I use to find the lowest number, but because of other programing changes the column now has #N/A in some of them.
=IF(COUNTIF(B163:B238,B239)>1,"NO","YES") This is in the next cell and it tells me if there is more than one of the smallest numbers.
Bookmarks