79139240

Date: 2024-10-29 23:15:00
Score: 1.5
Natty:
Report link

Let’s say your row is in cells A1:Z1. To count how many times each unique value appears, use this formula:

=MAX(COUNTIF(A1:Z1, A1:Z1))

Reasons:
  • Low length (1):
  • No code block (0.5):
Posted by: Kavinda Senarathne