Excel Help

[Deleted User]

I need some help with MS Excel. I am currently using the 2007 version. I have two worksheets, one is old.xls and the other is new.xls. Each of the worksheets have multiple columns and I would like to compare the columns from one worksheet with the other. The column names are VISIT NUMBER, CHECK IN, and CHECK OUT. There are other columns names, but they are not important. I am wanting to do a comparison for data integrity. I want to first match up the VISIT NUMBER and once I do have matches, I want to compare the CHECK IN date. Once the CHECK IN date matches I want to compare the matches for CHECK OUT date. I would like to somehow have the results displayed for matches based on all three categories and the ones that do not match. The CHECK IN and CHECK OUT are the secondary filters that I am interested in if they match or not based on the VISIT NUMBER. I am not sure if this will complicate things further but the CHECK IN date on the old.xls and the new.xls are in different formats. The old.xls is date and time like this 09/01/2009 9:54 and the new.xls is just date, like this 09/01/2009. The time of day is not important either just the date. I am not familiar with macros. I have over 60 thousand rows or customer information and searching one by one is not realistic. Any help would be greatly appreciated as I have absolutely no experience in Excel.

Thank you for any help,
Halen

mdaudioguy

The first thing I'd do is copy all the data from the old spreadsheet into a new worksheet in the newer spreadsheet (should be tabs along the bottom), so that both data sets are in the same file. This should make them easier to work with. I'd probably use the IF and LOOKUP functions to do some comparisons and flag any mismatched data. Try reading about them in the Help section. Don't worry much about the dates initially, as they are probably just formatted differently. It's the values that matter, not the format. Good luck!

JimKellyfan

I would need to see your sheets to better understand what you are trying to accomplish.
Maybe you can PM me, if it is something private ?
Judging just by what I see here, I would make sure to save the old file with 2 different names, the old name in the old format, and also hit save as in the new format. Excel 07 allows you to change and save in many formats.
Once that is done, you can copy paste and view, but with over 60k, that is a lot of looking. There are also formulas in Excel 07, called arguments. Excel 07 has a help section that is very friendly. In the top tab ( toolbar ) click formulas.
OK, once there, there is the logical drop down box. Click logical, then click true.
There are formulas, true and false you can utilize to help you.
Basically, you will tell the spreadsheet what to do in the cells corresponding to what is true and what is false.
That can be confusing, so when you click on true, you can also click on help with this function.
Try that.
As far as the dates, once you transfered the old to the new, or even before, you can highlight all the date boxes and adjust their formats so they match.
If you like, I can take a look at it if you send it to me or reply to this or PM or whatever.
Hope this helps, let me know, should you have any additional questions.
Too, there is free Microsoft training, besides a very in depth help function in 07. Link here: http://office.microsoft.com/en-us/support/training-FX101782702.aspx?redir=0

In addition to that, if you buy Office 07 now, you get a free upgrade to Office 10 in October. I work with it everyday ( when I am not out with hip replacement that is ), but then I recently bought from Newegg, three licenses, home and student for 119.99. So to me, that will transpose into three free office 10's.