Hi, I am trying to write a formula (in Col C & D) which can be used to select the most commonly/highly used word in Col B for each unique value in col A.
Column A Column B Column C Column D
TOA Apple TOA Apple
TOA Apple
TOA Apple
TOA Banana
TOA Grapes
TOB Orange TOB Orange
TOB Peach
TOB Orange
Any help is really appreciated, Thank you!!
Bookmarks