Previous Topic Next Topic

Min if

Closed
matt - Aug 6, 2009 at 08:33 PM
 matt - Aug 6, 2009 at 09:57 PM
I have a list of cities with associated flight costs. I am trying to find the minimum value, excluding zeros. I have tried a number of solutions, but haven't been able to get it to work.

Column A
AKRON
ANCHORAGE
APPLETON
ASHEVILLE
ATLANTA

Column B
AKRON
AKRON
ATLANTA
ATLANTA
ATLANTA
ATLANTA
APPLETON

Column C
100
200
300
0
500
0
200

For "Atlanta," I want to return a value of "300".... any ideas???
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 6, 2009 at 09:13 PM
in three empty cells e.g. A13,A14 and A15 type followin g

AKRON
ATLANTA
APPLETON

in B13 copy paste this formula

=MIN(IF((B1:B7=A13)*(C1:C7<>0),C1:C7))

hit control+shift+enter----------------IMPORTANT

copy B13 to B14 and B15
0
matt
Aug 6, 2009 at 09:57 PM
Yes!! That worked perfectly. Thanks for your help and quick response!
0

Similar discussions

opera min installing problem on gt-s3100
hussan -
faraz -

1 response
My computer turns off after 30 sec to 1 min
Arkthenoob -
vivek -

11 responses
TPLink W8151N is getting automatically restarted in every 15 min
Vineet -
vineet -

2 responses