Link to home
Create AccountLog in
Avatar of manju shukla
manju shukla

asked on

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
Avatar of John
John
Flag of Canada image

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
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ha!  Missed the MAX above - sorry
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of manju shukla
manju shukla

ASKER

Thanks, Thanks a lot. I have got my aswer.
Grateful for help.
You're welcome Manju! Glad we could help.
you are welcome manju

:)
closed as follows