Hey all,
Been trying to get this for hours!
I have this forumla
I need it to return the minimum value in the D range, where the C range is equal to I25. This is does fine, however there are zero/blank cells in the D range.
Please Login or Register to view this content.
I need it to return the minimum value in the D range that is not zero/blank.
Any ideas?
thanks very much
Hi,
Try this array
=MIN(IF(($C$2:$C$3653=$I25)*(NOT($D$2:$D$3653=0)),$D$2:$D$3653,""))
confirm with CTRL, SHIFT and ENTER
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Amazing, works perfectly. Thank you sir.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks