ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   comparing data in two spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/125005-comparing-data-two-spreadsheet.html)

klafert

comparing data in two spreadsheet
 
I have 2 spreadsheet. I have in column A invoice number in both spreadsheet.
In In speadsheet one (AR 2005 outstanding invoices.xls ) the invoice is only
listed once. However, in the 2nd spreadsheet , (2005sales.csv) t may be
listed more than once. I want spreadsheet 2005sales.csv to compare column A
(Invoice/CM# with column A (Invoice/CM#) in AR 2005 outstanding Invoices.xls
and return the value true or false so that I can sort 2005sales.csv and
delete the Invoice numbers that don't match.


All times are GMT +1. The time now is 03:40 AM.

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