Comparing, merging, calculating colums of data in Excel
- by hickster
I would like to create a formula that a) compares four columns of data (see below)
Sep Oct
name units name units
apple 2 apple 3
pear 3 pear 7
orange 4 banana 6
banana 3 toffee 5
then b) merges the two "names" column into one column, dropping any duplicates but still retaining the…