Hi, I'm trying to find the minimum value in a column of numbers for each case where the "counts" are identical. Spreadsheet attached to help explain..
I've been trying the following formula but I'm not getting the minimum..
=MIN(INDEX($c$4:$c82,MATCH(MAX($b$4:$b82),$b$4:$b82,0)))
what should I be doing? Thanks very much
Last edited by northerng; 05-27-2011 at 03:49 AM.
try this. comfirmed with ctr+shift+enter:
=IF(COUNTIF($B$7:$B7, B7)<COUNTIF($B:$B, B7), "", MIN(IF($B$7:$B$10000=B7, $C$7:$C$10000)))
great.. thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks