I am having some problems working out how I can create a solution for a gap analysis spreadsheet im creating.
I need to find the products that aren't listed in Sheet 1 by making excel refer to an array in Sheet 2.
For example. The following products are listed in sheet 1..
ICE BREAK COFF 500ML
ICE BREAK COFF 750ML
RUSH F/FREE 500ML
In total there are 6 products in the array on sheet 2.
I need to find which products aren't being displayed in Sheet 1 by referring to the array in Sheet 2, and then printing them in Sheet 1 into a seperate column which states that they are not ranged..
I also need the formulas to skip the results columns.
I have attached the spread sheet for your reference.
[url removed, login to view]
Anyhelp would be greatly appreciated....