beatdownkitty
New Member
- Joined
- May 24, 2016
- Messages
- 6
I need to obtain the most commonly used value (string) from a set of three rows in 3 category columns and then output this word into the result column. The matching is based off the rows though not the columns. So Row 2's most commonly used word from these three columns is "Marketing"
<tbody>
</tbody>
The formula would need to take into account the chance of an #N/A value along with cells containing two words in this case "Secure Development." I've tried a few different things but in no way am I anything close to being great at excel...Result column would be where the most commonly used word is outputted.
1 | Category 1 | Category 2 | Category 3 | Result |
2 | Marketing | Marketing | #N/A | Marketing |
3 | Secure Development | Marketing | Secure Development | Secure Development |
4 | Secure Development | Secure Development | #N/A | Secure Development |
<tbody>
</tbody>
The formula would need to take into account the chance of an #N/A value along with cells containing two words in this case "Secure Development." I've tried a few different things but in no way am I anything close to being great at excel...Result column would be where the most commonly used word is outputted.