PDA

View Full Version : find min value of specific designation



syed_iqbal
02-17-2017, 09:24 PM
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
02-18-2017, 08:12 AM
C1 Formula: =MIN(B:B)

p45cal
02-18-2017, 09:23 AM
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
02-18-2017, 10:25 AM
I'd give you a Rep Point, but I have to "spread some around" first.

syed_iqbal
03-17-2017, 06:04 AM
Thank you very much p45cal (http://www.vbaexpress.com/forum/member.php?3494-p45cal)