Excel

Is is possible to count    Max salary  of Male as well as    Max Salary of Female in an organization. For Exp -
Name Gender Salary
Rohan         M                   60000
Peeyush      M                  40000
Smita           F                   55000
Gauri           F                   35000
and so on. Using Function
manju shuklaAsked:
Who is Participating?
 
ProfessorJimJamConnect With a Mentor Commented:
For male =Max(if(B:B="M",C:C))
For female =Max(if(B:B="F",C:C))

Formula should be entered using control shift enter

Also the example is given that gender is in column B and salary is in column C

You can change those range to actual range in your workbook
2
 
JohnBusiness Consultant (Owner)Commented:
I use COUNTIF for this. Set M and F in a column and count the next column using the M/F column as the selector

https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34
0
 
JohnBusiness Consultant (Owner)Commented:
Ha!  Missed the MAX above - sorry
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Assuming E3=M and E4=F and data is in the range A2:C5 then try this....
In F3
=MAX(INDEX(($B$2:$B$5=E3)*($C$2:$C$5),))

Open in new window

and copy down. No need to use Ctrl+Shift+Enter, Enter alone is sufficient as this is a regular formula.

Also you may use the Pivot Table to get the desired output.

Please refer to the attached for details.
Max-Salary.xlsx
1
 
manju shuklaAuthor Commented:
Thanks, Thanks a lot. I have got my aswer.
0
 
manju shuklaAuthor Commented:
Grateful for help.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Manju! Glad we could help.
0
 
ProfessorJimJamCommented:
you are welcome manju

:)
0
 
ProfessorJimJamCommented:
closed as follows
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.