[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel

Posted on 2016-08-27
9
Medium Priority
?
47 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 98

Expert Comment

by:John Hurst
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 27

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 98

Expert Comment

by:John Hurst
ID: 41772994
Ha!  Missed the MAX above - sorry
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 33

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 33

Expert Comment

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

Expert Comment

by:ProfessorJimJam
ID: 41781348
you are welcome manju

:)
0
 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 41808377
closed as follows
0

Featured Post

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.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

649 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