How do I select a range if one cells contents is equal to another

[Guest]

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.

 

[Frank Kabel]

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

 

[Domenic]

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!