find min value of specific designation

[syed_iqbal]

Hi,


recently i saw one simple question on net and tried in excel by using formula, but i did n't get the answer . pls help

Designation Salary
Exec 8000
Manager 15000
Admin 10000
Exec 9000
Manager 25000
HR 20000
Exec 7500
Admin 10000
Manager 22000
Exec 9200

Question is: Find minimum salary of Executive.

[SamT]

C1 Formula: =MIN(B:B)

[p45cal]

Find minimum salary of Executive.

Exec=Executive right?

C1 Formula: =MIN(B:B)

While this gives the right answer it's because it is the lowest salary of all.
If it's just the Execs you want to find the lowest salary of, try array-entering (commit the fomula to the sheet with Ctrl+Shift+Enter, not just Enter) this formula:
=MIN(IF(A3:A12="Exec",B3:B12))

[SamT]

I'd give you a Rep Point, but I have to "spread some around" first.

[syed_iqbal]

Thank you very much p45cal