Unique Items

Input: Sample file with base data.

Download sample input files here

Goal: Apply lookup with respect to bank column. In report, There should be all unique company names corresponding to each bank.


1.Select key range and lookup range from given sample file.

2.Match criteria will be Bank(lookup table)=Bank(key values)

3.Report all column with function 'Unique Items'