Excel BI Challenge Workout 038

Workouts Excel BI Challenge
1

— CAN YOU SOLVE THIS - EXCEL CHALLENGE 38 —
(Power Query solutions also welcome for Excel Challenges)

Find the employees having same salary as any other employee.
And not having same salary as any other employee.

(Post answers in Comment. Your formula need not be different from others as long as you have worked out your formula independently)

Download Practice File - https://lnkd.in/dxT6-Q_U

#excel, #challenge, #advancedexcel, #excelchallenge, #excelproblem, #excelquestion, #excelsolution, #excelformulas, #excelfunctions, #exceltips, #exceltricks, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #M, #powerpivot

image
image1019×619 76.7 KB

Excel BI’s LinkedIn Post

2 
=LET(e,A2:A10,s,B2:B10,
ss,FILTER(e,COUNTIFS(s,s)>1),
ns,FILTER(e,COUNTIFS(s,s)=1),
h,{"Same Salary","Not Same Salary"},
b,IFNA(HSTACK(ss,ns),""),
VSTACK(h,b))

Same Salary- Quadri Atharu.xlsx (23.3 KB)

3
Summary

Munachi_Same Salary.xlsx (2.4 MB)

=IF(COUNTIF($B$2:$B$10,B2) > 1,"same salary", "Not same salary")