.. just make a copy of the original sheet (where col A is compared
against col B), then swap the 2 source lists in cols A and B around.

To "swap", in the copied sheet, clear cols A and B (select the cols and
press Delete key), then go back to the original sheet and copy col A, paste
it into col B in the copied sheet, then repeat to copy & paste col B from the
original into col A in the copied sheet. Then just ensure that the formula
fills are sufficient to cover the new data extent in col A. Do not delete
the cols as this will foul up the formulas.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---