I have multiple columns of data. In the first two columns I need to find
whether their value is equal .... I can achieve this by using the exact
formula. Is there is a match then I wish to select all the columns of data.

Hi
not completely sure what you're trying to do. Could you give an example?

--
Regards
Frank Kabel
Frankfurt, Germany
"KHarrison" schrieb im Newsbeitrag
...
I have multiple columns of data. In the first two columns I need to find
whether their value is equal .... I can achieve this by using the exact
formula. Is there is a match then I wish to select all the columns of
data.

In article ,
KHarrison wrote:

I have multiple columns of data. In the first two columns I need to find
whether their value is equal .... I can achieve this by using the exact
formula. Is there is a match then I wish to select all the columns of data.

Assuming that Columns A, B, C, and D contain your data, try the
following array formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

E1, copied across and down:

=IF(ISNUMBER(SMALL(IF(($A$1:$A$10<"")*EXACT($A$1: $A$10,$B$1:$B$10),ROW($
A$1:$A$10)),ROW()-ROW($E$1)+1)),INDEX(A:A,SMALL(IF(($A$1:$A$10<"")* EXACT
($A$1:$A$10,$B$1:$B$10),ROW($A$1:$A$10)),ROW()-ROW($E$1)+1)),"")

Adjust the range accordingly.

Hope this helps!