count the same values

Originally Posted by Marcol

Here's a method using various formulae, paste special, transpose and text to columns.

You might be able to do a better job with the vertical values.

Thanks Marcol,

That does the trick.