FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,362
- Office Version
- 365
- 2016
- Platform
- Windows
I know if Excel there is the MODE.MULT function to return the most occurring value, but that display in separate cells. Does somebody know of a UDF that can return the most occurring separated by a comma? Results in column G
Excel 2016 (Windows) 64 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Excel 2016 (Windows) 64 bit
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | 1 | 2 | 1 | 2 | 1 | 2 | 1, 2 |
2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
3 | 4 | 5 | 6 | 4 | 5 | 6 | 4, 5, 6 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1