=
FormulaCraft
Formulas
How-to
Fix errors
Pricing
Workspace
Auditor
Verify
Sign in
Get started
Formula workspace
Describe it, paste one to explain, or paste a broken one to fix.
Generate
Explain
Fix
Excel
Google Sheets
=ARRAYFORMULA(RANK.EQ(A2:A7, IF((B2:B7=B2)*(C2:C7=C2), A2:A7), 0))
.
⌘↵ to run
Generate formula
Workspace | FormulaCraft