I need to count how many times an item went from a certain source, and afterwards from which source it went the most.
Say...
<tbody>
</tbody>
How do I, on a new sheet add next to the cell with value "Apple", columns Wallmart/Target/Newegg, and how many times they appeared related to the value "Apple", or oranges etc.
And/or, just return the "Source" that appeared the most related to the value Apple.
If needed I can provide an actual file with example.
Regards
Say...
Source | Item |
Wallmart | Apple |
Wallmart | Apple |
Newegg | Apple |
Target | Apple |
Wallmart | Apple |
Target | Apple |
Wallmart | Apple |
<tbody>
</tbody>
How do I, on a new sheet add next to the cell with value "Apple", columns Wallmart/Target/Newegg, and how many times they appeared related to the value "Apple", or oranges etc.
And/or, just return the "Source" that appeared the most related to the value Apple.
If needed I can provide an actual file with example.
Regards