ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comparing data (https://www.excelbanter.com/excel-worksheet-functions/125809-comparing-data.html)

Excel Help!

Comparing data
 
I need to compare data from 2 worksheets. There are three rows of data I
need to compare in each worksheet:
WS - A
A,B,C,D,E,F,

WS - B
A,B,C,D,E,F

I need to compare WS-A, row B,D,F with WS-B row B,D,F and store the
different in a third worksheet and/or apply conditional formatting to both
worksheets. I would appreciate any help. Thanks.....



All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com