Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have set up two tabs within a worksheet with some data I want to compare.
The first is entitled "Before" and the second "After". On the third tab (called "Comparison") I want to write a query of some type that looks at the data on the "Before" tab and the data on the "After" tab. If the information is the same, it leaves the cell blank on the "Comparison" tab; if the information is different, it inserts a statement that says "Data does not match". Since I'm new to comparing data in Excel (I have 51,000 lines of data that was imported from two .TXT files) is there a quick and easy way to do this? Thanks. -- Excel Newbie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
need help comparing data in 2 separate worksheets | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |