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

K

KHarrison

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.
 
D

Domenic

KHarrison said:
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.
Click to expand...

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!
 
Top