| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
| Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
