Forum Discussion
MdAhad42
Jul 03, 2021Copper Contributor
Rank+ Countif
Hello everyone, I am new to Microsoft Tech Community. I hope you all are doing well and are safe. The issue I am facing using rank and count if function. I want a multiple criteria to get a rank. I...
PeterBartholomew1
Jul 10, 2021Silver Contributor
Just for entertainment, I used Lambda functions within Excel 365
to define a formula based upon the Lambda function
= RANKλ(range1,0,range2,0,range3,1)
German_Chris
Jul 10, 2021Iron Contributor
I think 0,05% of the users have Lambda at the moment ….
- PeterBartholomew1Jul 10, 2021Silver ContributorTrue, but I can still seed the idea that change is possible! My guess would be that many spreadsheet users would not even recognise the solution as an Excel formula.