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.

Hint:

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'