default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
If I have a spreadsheet like this (below), is there a way to display the top recurring item (from cells A, B and C) in the cells in Column D, like so?
I added notes on the right side.
<tbody>
</tbody>
Is this even possible?
Thanks in advance for your help!
I added notes on the right side.
A | B | C | D | ||
1 | Group A Item(s) | Group B Item(s) | Group D Item(s) | Top Recurring Item | |
2 | Apple Orange Taco | Cheese | Apple Mayo Ham | Apple | <--This is an example of ONE obvious result...since all items are listed only once, except Apple (which appears twice) |
3 | Apple Beef Cheese Soda | Soda Plum Cups | Apple Soda Chili | Soda | <--Although Soda appears 3 times, and Apple appears 2 times, Soda would be outputted since 3>2 |
4 | Orange Chicken Flour | Spam | Mayo Parsely | No Recurring Items | <--Since there aren't any recurring items in these cells, the result is just text stating the obvious |
5 | Tomato Flour Mustard Fries Bread | Taco Turkey Flour | Bread Corn | Bread Flour | <--This is an example of a tie. Bread appears twice, as does Flour. As a result of a tie, both Bread and Flour are outputted. |
<tbody>
</tbody>
Is this even possible?
Thanks in advance for your help!