Try (untested)
=MIN(IF(AND(A3=$A$3:$A$19,$C$3:$F$19>0),$C$3:$F$19))&" - "&MAX(IF(AND(A3=$A$3:$A$19,$C$3:$F$19>0),$C$3:$F$19))
Not sure if this will work actually.
Try (untested)
=MIN(IF(AND(A3=$A$3:$A$19,$C$3:$F$19>0),$C$3:$F$19))&" - "&MAX(IF(AND(A3=$A$3:$A$19,$C$3:$F$19>0),$C$3:$F$19))
Not sure if this will work actually.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks