I'm trying to figure out how many time a certain value (alphanumeric "AB1") shows up in a string of cells (H5:H875).

If it is possible, It would also be nice to somehow count how many times certain combinations show up in different cells.

For example;

I have alphanumeric values in cells H5:H875, and more alphanumeric values in K5:K875.

I want to return how many times the combination of "AB1" in the H column, and "BA1" match up in the same row, in the K column.

If that makes sense.

Any help would be appreciated.

Cheers,
Dan