Excel: Look up function for combinations of cells in a single column

Posted by Rebecca on Super User See other posts from Super User or by Rebecca
Published on 2013-10-25T15:13:24Z Indexed on 2013/10/25 15:57 UTC
Read the original article Hit count: 247

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!

© Super User or respective owner

Related posts about microsoft-excel

Related posts about worksheet-function