I have a set of data and want to compare the differences between 2 rows but also label what column the differences appear.
Type Units Cost Dogs. 5. £20 Dogs. 5. £25
Result would be - Cost: £25
The difference could be in any column or more than 1 column
Type Units Cost Dogs. 5. £20 Dogs. 6. £25
Result would be - Units: 6, Cost: £25
Could not work out what formula to use on this.