Uploaded March 2013 | Updated September 2026, 2 hours ago

---

Here is a technique that I use to rank only the visible numbers. Only 2 functions: SUBTOTAL and COUNTIFS