I have 3 sheets in my calc document
each one contains a column of data
In theory all columns should have the same data
I need a way so that on sheet 4 I can:
-Have 3 columns labelled to reference each sheet
-In each of these columns only display the information that does not have a match on the sister sheets,
-Ideally it would show if say , Sheet 1 and 2 had a match but that data was only missing from sheet 3.
Also the columns may have the data listed in separate orders , so the cells may not match up if put side by side as each sheet has different formatting