<div>
Hi, thank you for your reply. &nbsp;they are in the same workbook. &nbsp;Highlighting would be great. &nbsp;If possible in another workbook would be ideal!!
</div>


Hi, thank you for your reply.  they are in the same workbook.  Highlighting would be great.  If possible in another workbook would be ideal!!

EE-DuplicateRowsAcrossSheets.xlsx

<div>
Hi,<br />
<br />
Have you had a chance to review my solution provided above? &nbsp;If so and you still have questions, please let me know. &nbsp;Otherwise, can you please properly close this question by clicking the &quot;Accept this solution&quot; link above my post above?<br />
<br />
With Thanks,<br />
Glenn
</div>


Hi,

Have you had a chance to review my solution provided above?  If so and you still have questions, please let me know.  Otherwise, can you please properly close this question by clicking the "Accept this solution" link above my post above?

With Thanks,
Glenn

<div>
<div class="content wysiwyg-content">
hello,<br />
<br />
having an issue... have two different spreadsheets. &nbsp;I need to compare the two spreadsheets to filter only same columns. &nbsp;In other words, which rows are the same in both spreadsheets. &nbsp;is there a simple formula that could be used or a free program that would do that?<br />
<br />
Thanks!
</div>
</div>


hello,

having an issue... have two different spreadsheets.  I need to compare the two spreadsheets to filter only same columns.  In other words, which rows are the same in both spreadsheets.  is there a simple formula that could be used or a free program that would do that?

Thanks!

Excel formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.