Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Compare 2 sets of data and return a true or false in a third column.
Can i use Pivots or lookups or any functions I need list 2 to look at list 1 and compare and let me know that ID 1 is mapped to the same Name & return true/false. What makes it complicated is that Some IDs have 2 names mapped to it & the names can be different. But even if 1 of the name is different, if it returns a false, it will be sufficient. List 1 List 2 ID Name ID Name 1 RW 1 RPS 2 ROP 2 CPM 3 RW 2 ROP 4 EPR 3 RW 5 DCE 4 DCE 5 RW 5 EPR 5 RW This is what the result should look like. ID Name 1 RPS False 2 CPM False 2 ROP False 3 RW True 4 DCE False 5 EPR False 5 RW False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) |