I have a set of spreadsheet data taken at time T1. Two columns A:B. Col A holds rows of 4 digit reference, Col B with £ values.
I now have another set of data taken at T2 with same format. There may be more or less rows compared to data at T1.
I would like to list the row data that matches between T1 and T2 by:
(1) the 4 digit reference only
(2) both the 4 digit reference and value
(3) data that does not match
I hope I make sense. Any help would be much appreciated
PS - formulas I'm happy with; VBA you'll need to go gently!