Dear Momoh, I like to give long names to variables 😃: =LET(_Department,A2:A20,_Salary,C2:C20,_EmpName,B2:B20, GROUPBY(_Department,_EmpName,ARRAYTOTEXT,0,0,, _Salary>=MAP(_Department,LAMBDA(_Dept,LARGE((_Department=_Dept)*(_Salary),2))))) 🤗
Thanks again I've learned a lot re Lambda functions from your work, one thing, to be thorough, I'd wrap in Unique before search for 2nd highest ; LET(test, LARGE(UNIQUE( ($Q$5:$Q$20=Q5)*($R$5:$R$20)),2),R5>=test).
Great challenge. Great solution. Thank you for sharing it!
Brilliant, great solutions and very well explained. Thanks Victor (Just need the GROUPBY function now!!!!)
Good to see you back - hope all is well, and Happy New Year!
@@charlesmurtaugh3771 oh yea. Glad to be back
Thank you master❤
You are welcome
Dear Momoh,
I like to give long names to variables 😃:
=LET(_Department,A2:A20,_Salary,C2:C20,_EmpName,B2:B20,
GROUPBY(_Department,_EmpName,ARRAYTOTEXT,0,0,,
_Salary>=MAP(_Department,LAMBDA(_Dept,LARGE((_Department=_Dept)*(_Salary),2))))) 🤗
@@JoseAntonioMorato long names are good, more descriptive. So nothing wrong with that
Thanks again I've learned a lot re Lambda functions from your work,
one thing, to be thorough, I'd wrap in Unique before search for 2nd highest ;
LET(test, LARGE(UNIQUE( ($Q$5:$Q$20=Q5)*($R$5:$R$20)),2),R5>=test).