![]() |
2 worksheets compare a range of data, create 3rd worksheet w/diffs
I have 2 worksheets, one with 6 columns of data and the other with 12 columns
of data. Both have an unspecified number of rows. The data in the first worksheet(6 columns, A-F) needs to be compared with the data in the second worksheet(12 columns, but only columns G-L need to match the data in the first worksheet columns A-F). I need to create a 3rd worksheet showing the data in the rows that did not match across the 2 worksheets. The first two worksheet's data is not sorted so the rows don't line up across the sheets. e.g. worksheet 1 data columns A-F SPX OCT 2008 800 0 1200 SPX OCT 2008 900 0 -1400 SPX OCT 2008 975 0 200 worksheet 2 data columns G-L SPX OCT 2008 900 0 -1400 SPX OCT 2008 800 0 1200 SPX OCT 2008 975 0 100 The only data that will show up in the 3rd worksheet is SPX OCT 2008 975 0 200 and SPX OCT 2008 975 0 100 Any help is greatly appreciated. |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com