Show 1st, 2nd, 3rd often entry of a column
we use a sheet to collect incidents for the Facility Department (FM Tracker).
I want to show in a dashboard which are the incidents that occur most (rank 1, 2, 3)
In the sheet summary I already tried this:
=COUNTIFS(subject1:subject30); MAX(subject1:subject30); RYG:RYG; "rot") => #unparseable
Any ideas? ;-)🙄
Help Article Resources
Check out the Formula Handbook template!