I am trying to sort info based on the most recent database it appeared in.
Column A has the Master List, and outlying columns have other info. Column B
has the most recent list (call it 2006), Column C is 2005, Column D 2004. In
Column E I want to put the the most recent list that the items in Column A
show up in. I am trying to use IF(OR(EXACT))) to compare items in Column A
successively with each row. Something like:
=IF(OR(EXACT(A1,B:B)),"2006",IF(OR(EXACT(A1,C:C)), "2005",IF(OR(EXACT(A1,D:D)),"2004",
"NEW"))). Getting #NUM error. Tried CONTROL-SHIFT-ENTER at end, but not sure
if problem is all are not arrayed.