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,
1 Reply
CNENFRNLCommunity Champion
Simple enough, the PIVOTAL step is to UNPIVOT the dataset.
A showcase of powerful Excel worksheet formula,