Hi there. I have 2 lists of data that I need to compare for likeness or diff.
Column A has a list that column C's list has some same values and maybe some diff values.
I need to align a new list column F to show the values that are the same as well as add the values that may be diff from each list but keep in the same order as they appear.
Column A
Duck
Goose
Zebra
Giraffe
Column C
Duck
Goose
Deer
Antalope
Giraffe
Column F
Duck
Goose
Deer
Antalopee
Giraffe
Hope this helps. Thanks.