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 order (say F1 F3 F4) occurs, in this example 3 times (in my case the lookup sequences are 8 cells long). Is there a way to run over the whole column and identify the instances where this combination of cells occurs?
I'm running Excel 2008 for Mac.
Many thanks!