Hi

I am trying to create a formula which I have no idea about. Based on the
example below can someone please help.

I have an array (eg A3:F30) where each row is a unique series of numbers.
eg 5.555,106.45, 57, 33.66, 8765, 33,

I want to be able to check each unique series (row) of numbers in the array
against another singular series of numbers (row) of numbers and if there is
match then put an identifiying mark (e.g T, 0 or 'match') in the column
adjacent to the row to the ones that match with my array.

Can someone tell me how to do this?

thanks

*Maybe* this:

Assume the lookup numbers are in the range A1:F1

Enter this formula in H3 and copy down to H30:

=IF(SUMPRODUCT(COUNTIF(A3:F3,A$1:F$1))=6,"Match"," ")

--
Biff
Microsoft Excel MVP


"M" wrote in message
...
Hi

I am trying to create a formula which I have no idea about. Based on the
example below can someone please help.

I have an array (eg A3:F30) where each row is a unique series of numbers.
eg 5.555,106.45, 57, 33.66, 8765, 33,

I want to be able to check each unique series (row) of numbers in the
array
against another singular series of numbers (row) of numbers and if there
is
match then put an identifiying mark (e.g T, 0 or 'match') in the column
adjacent to the row to the ones that match with my array.

Can someone tell me how to do this?

thanks