Count unique text values in range with criteria

Hello,

I am trying to count the number of unique values in a range (four columns wide, called Name One through Name Four) based on some criteria (currently just the Year). The problem is that my values are in text format so I can't do this:

Please Login or Register  to view this content.

So this is what I am trying:

Please Login or Register  to view this content.

But this second formula doesn't work, seemingly because the range in the Match function is a range that has more than one column.

These formulas I have tried came from Microsoft's Excel Help. Any ideas on what formula I should try instead?

I attached a sample, but it's not very pretty.

Thanks

-**-

I'm considering converting the text to numbers by way of

Please Login or Register  to view this content.

In which case I can use the formula in my first post that works for numbers.

Please let me know if you have a better approach that doesn't involve converting the text to numbers.

Cdiaz

Nevermind, that doesn't work. When converted to numbers, Excel doesn't think 8311610111810111011544327697119114101
is different from
8311610111810111011511111044327710599

If figured it was a long shot anyway.

Ideas? Is this even possible? It's easy with several columns of numbers and easy with one column of text, but what about several columns of text?

bump no response