?
Solved

Excel

Posted on 2016-08-27
9
Medium Priority
?
46 Views
Last Modified: 2016-09-21
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
0
Comment
Question by:manju shukla
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 97

Expert Comment

by:Experienced Member
ID: 41772965
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
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 1000 total points (awarded by participants)
ID: 41772985
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
 
LVL 97

Expert Comment

by:Experienced Member
ID: 41772994
Ha!  Missed the MAX above - sorry
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 32

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 1000 total points (awarded by participants)
ID: 41773018
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
 

Author Comment

by:manju shukla
ID: 41781111
Thanks, Thanks a lot. I have got my aswer.
0
 

Author Comment

by:manju shukla
ID: 41781112
Grateful for help.
0
 
LVL 32

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41781168
You're welcome Manju! Glad we could help.
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41781348
you are welcome manju

:)
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41808377
closed as follows
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question