LinkBack URL
About LinkBacks
mrudd72 
I have an existing formula that finds the lowest number if it isn't a duplicate..
=IF(COUNTIF(H10:H89,MIN(H10:H89))=1,MIN(H10:H89),0)
The problem is, it is counting zeros. Can I modify this so it won't count the zeros?
I have an existing formula that finds the lowest number if it isn't a duplicate..
=IF(COUNTIF(H10:H89,MIN(H10:H89))=1,MIN(H10:H89),0)
The problem is, it is counting zeros. Can I modify this so it won't count the zeros?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks