Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I compare 2 spreadsheets of data?
help! I am trying to compare 2 separate files of patient data. I have a
unique identifer in Column E on both files (patient name and date). I would like to compare the appointment list (patient name and date) to the list I receive back from the billing company (patient name and date) to make sure all the patients were billed. If the patient's name on the appointment list did not appear on the billing list, I would know that person was not billed. I know this is possible, but can't for the life of me figure out how to do it. I'm into this problem for 2 full days now!! Any help would be very appreciated. Thank you, Teena |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I compare 2 spreadsheets of data?
On Nov 15, 7:24 am, TEENA wrote:
help! I am trying to compare 2 separate files of patient data. I have a unique identifer in Column E on both files (patient name and date). I would like to compare the appointment list (patient name and date) to the list I receive back from the billing company (patient name and date) to make sure all the patients were billed. If the patient's name on the appointment list did not appear on the billing list, I would know that person was not billed. I know this is possible, but can't for the life of me figure out how to do it. I'm into this problem for 2 full days now!! Any help would be very appreciated. Thank you, Teena Hello Teena You could link those file to an Access mdb...where you could create a query which would be a lot easier to manage. If you want to do it completely in Excel: Go to your first free column and enter this in row1 (or row2 if row1 are titles): =IF(E1="","",IF(ISERROR(VLOOKUP(E1,Sheet2!E:E,1,FA LSE)),"Not Billed","Billed")) where E1 is the first cell of the column you want to compare. Sheet2 is the sheet your Data to compare is stored E:E is the column where you want to compare the data. After that you can make an autofilter and show all "not billed" hth Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I compare and filter data in 2 spreadsheets | Excel Worksheet Functions | |||
How do I compare data between spreadsheets? | Excel Worksheet Functions | |||
Compare data on two spreadsheets. | Excel Discussion (Misc queries) | |||
compare data from several spreadsheets | Excel Discussion (Misc queries) | |||
how do I compare data in Exel spreadsheets? | Excel Discussion (Misc queries) |