Forum Discussion
Officeuser7777
Jun 20, 2024Copper Contributor
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...
- Jun 23, 2024
It may already have been suggested but COUNTIFS works perfectly well with 2D Ranges.
fruit = UNIQUE(TOCOL(Tabelle1,1)) count = COUNTIFS(Tabelle1, fruit)
PeterBartholomew1
Jun 23, 2024Silver Contributor
It may already have been suggested but COUNTIFS works perfectly well with 2D Ranges.
fruit
= UNIQUE(TOCOL(Tabelle1,1))
count
= COUNTIFS(Tabelle1, fruit)
- Officeuser7777Jun 24, 2024Copper Contributor
Peter and Oliver, thank you. That worked great. Wish I could tag you both with best answer.