Forum Discussion
Counting within 3 columns
Hi, not feeling too smart here. How do I code Excel to make the result table below, counting number of unique occurrences of fruit types across 3 columns? Col1 etc refer to Table columns in DataTable...
It may already have been suggested but COUNTIFS works perfectly well with 2D Ranges.
fruit = UNIQUE(TOCOL(Tabelle1,1)) count = COUNTIFS(Tabelle1, fruit)
It may already have been suggested but COUNTIFS works perfectly well with 2D Ranges.
fruit
= UNIQUE(TOCOL(Tabelle1,1))
count
= COUNTIFS(Tabelle1, fruit)
Peter and Oliver, thank you. That worked great. Wish I could tag you both with best answer.
