compare two columns data and bring them to another work sheet

E

EXCEL USER

I want to compare column d and column f. if the data match i would like to
bring the entire data for each of that raw into another work sheet. there
are total of 8 columns and 2500 raws. please help me to write the fromula or
show me how i can do that. please e-mail me at [email protected].
thank you,

nk1519
 
D

David Biddulph

On your second sheet, in cell A1, put the formula
=IF(Sheet1!$D1=Sheet1!$F1,Sheet1!A1,""), and copy across your 8 column &
down your 2500 rows.

Please don't ask for an answer to be e-mailed to you. If you ask a question
in a newsgroup, then you get the answer in the newsgroup, so that if the
answer is useful it can be used by others, and so that if the answer is
wrong (or can be improved) it can be corrected by those who know better.
 
Top