Excel: Look up function for combinations of cells in a single column
- by Rebecca
I'm looking to find the number of times a certain combination of values appears in a single column, I was hoping to do this in Excel but I'm starting to think it may not be possible.
As an example, I have a list that looks like a longer vertical version of this:
F1
F3
F2
F4
F1
F3
F4
F1
F3
F4
F1
F3
F4
And I want to know how many times a specific…