Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Similiar data on two different sheets - how to ID what is differen
I have some employee data from two different sources (on two separate tabs).
On 3rd tab, I'd like to show if the data is on sheet A , but not on sheet B, and vice-versa. E.g. Sheet A Employee ID Name 12345 John 78910 Mary 45678 Joe Sheet B Employee ID Name 12345 John 45678 Joe 77777 Jill So I'd like to have in Sheet C something to the effect of: Mary is in sheet A, but not B & Jill is in sheet B, but not A. Another thing I'd like to be able to do is: One of the sheets shows days off as follows NNNNYYN Y's meaning they're off Wed & Thurs the other sheet shows WedThu as their days off Can I also get someting to indicate that for that particular employee ( ID) if NNNNYYN meaning off Wec & Thu on one sheet, but shows FriSat on the other, to produce an Alert such as "day offs don't match"" ? Much thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Something similiar to conditional formatting | Charts and Charting in Excel | |||
SUMPRODUCT or some similiar function | Excel Worksheet Functions | |||
how to combine two similiar sheet | Excel Worksheet Functions | |||
Looking for something similiar to MIN | Excel Worksheet Functions | |||
how to merge 2 different versions of same file edited on differen. | Excel Discussion (Misc queries) |