<div>
Hi Katie,<br />
When I paste that function in an xl sheet on sheet b cell B1, it just puts in the text of the function, it doesn't return any results. I also noticed that in your range referring to Sheet A, it says $A10000$, should there be a $ at the end of the range reference?<br />
<br />
Thanks,
</div>


Hi Katie,
When I paste that function in an xl sheet on sheet b cell B1, it just puts in the text of the function, it doesn't return any results. I also noticed that in your range referring to Sheet A, it says $A10000$, should there be a $ at the end of the range reference?

Thanks,

<div>
Sorry, that should read, &quot;$A$10000&quot; (or whatever range you want).<br />
<br />
To correct what appears in the cell, check the formatting and make sure it's not Text formatting.
</div>


Sorry, that should read, "$A$10000" (or whatever range you want).

To correct what appears in the cell, check the formatting and make sure it's not Text formatting.

<div>
Except for the tupo which the Expert corrected in a later email, this solution worked perfectly. I was able to paste the correct function in a cell and it returned what I was looking for.
</div>


Except for the tupo which the Expert corrected in a later email, this solution worked perfectly. I was able to paste the correct function in a cell and it returned what I was looking for.

<div>
<div class="content wysiwyg-content">
In XL 2010, I have 2 worksheets, one has thousands of rows of data (Sheet A) and the other has hundreds of rows of data (Sheet B). Some of the data in sheet B is in Sheet A. How can I find out which data in sheet B is also in Sheet A?<br />
<br />
Thanks,
</div>
</div>


In XL 2010, I have 2 worksheets, one has thousands of rows of data (Sheet A) and the other has hundreds of rows of data (Sheet B). Some of the data in sheet B is in Sheet A. How can I find out which data in sheet B is also in Sheet A?

Thanks,

compare data in 2 different excel 2010 worksheets

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