Forum Discussion
Solved
Calculate mode in one row
I want to find mode in one row and mark other values as different color Like below I know how to find mode,but how to find mode in per row?
Simple enough, the PIVOTAL step is to UNPIVOT the dataset.
A showcase of powerful Excel worksheet formula,
CNENFRNL
Community Champion
Community ChampionSimple enough, the PIVOTAL step is to UNPIVOT the dataset.
A showcase of powerful Excel worksheet formula,