Removing duplicate cells

[talltai]

I have scoured the threads and I still haven't reached a resolution to the following issue.

I am creating a dashboard and one of the sections has a rollup by Part Type. I used an Index/Match combo to Rank the number of parts that appear as the Top 3. Of course, this produced duplicates in some categories. Any solution I have read only considers either 2 columns of data or assumes the duplicates are by row but my data is in a 22x6 matrix. How can I use a formula or a macro to pluck out all duplicates that appears in a category or basically at the row level but across multiple columns (at least 4).

Basically I want to compile the total results for each row (item type) into a consolidated Top 3 without duplicates.

	Nth from the Top	Nth from the Bottom
Item Type	1	2	3	1	2	3
Access Point	CISCO AIRONET	ADTRAN TOTAL ACCESS 924E	ADTRAN TOTAL ACCESS 924E	ADTRAN TOTAL ACCESS 924E	CISCO AIRONET	ADTRAN TOTAL ACCESS 924E
Adapter	ALCATEL 6850 ADAPTER	ALCATEL 6850 ADAPTER	ALCATEL 6850 ADAPTER	ALCATEL 6850 ADAPTER	ALCATEL 6850 ADAPTER	ALCATEL 6850 ADAPTER
Cable	CSN, CABLE, MOLEX HP CISCO 50CM STACKING CABLE	CSN, CABLE, HP SATA DVD DATA/POWER CABLE	DL380 G6 CMA	DL380 G6 CMA	CSN, CABLE, HP SATA DVD DATA/POWER CABLE	CSN, CABLE, MOLEX HP CISCO 50CM STACKING CABLE
Carrier	PER320 HD CARRIER	0	0	PER320 HD CARRIER	0	0
Console	CSN, ASSY, HP TFT7600 KVM Console AZ870A	CSN, SWIT, HP KVM SERVER CONSOLE G2 0X2X8 AF616A	CSN, ASSY, HP TFT7600 KVM Console AZ870A	CSN, ASSY, HP TFT7600 KVM Console AZ870A	CSN, SWIT, HP KVM SERVER CONSOLE G2 0X2X8 AF616A	CSN, ASSY, HP TFT7600 KVM Console AZ870A
Controller	PER320 CONTROLLER	0	0	PER320 CONTROLLER	0	0
Cradle Point	CRADLE POINT SIM	CRADLE POINT CBA 850	CRADLE POINT CBA 850	CRADLE POINT CBA 850	CRADLE POINT CBA 850	CRADLE POINT SIM
Disk	CSN, SPS-DRIVE, DVD-ROM SLIMLINE OPTICAL DISK DRIVE0SATA INTERFACE 12.7mm	0	0	CSN, SPS-DRIVE, DVD-ROM SLIMLINE OPTICAL DISK DRIVE0SATA INTERFACE 12.7mm	0	0
Firewall	CISCO ASA 5525 FIREWALL	CISCO ASA 5525 FIREWALL	CISCO ASA 5525 FIREWALL	CISCO ASA 5525 FIREWALL	CISCO ASA 5525 FIREWALL	CISCO ASA 5525 FIREWALL
Hard Drive	DL380 G6/G7 300GB HD	PE2900	DL380 G6/G7 300GB HD	PER320 2TB HD	DL380 G6/G7 300GB HD	PER320 2TB HD
Kit	CSN, APC KEYBRD MOUSE MONITOR	CSN, APC KEYBRD MOUSE MONITOR	0	CSN, APC KEYBRD MOUSE MONITOR	CSN, APC KEYBRD MOUSE MONITOR	0
Memory	CSN, 4GB 1333MHZ PC3-10600R, DUAL RANK, DDR3 DIMM	PER320 8GB MEM	PER320 8GB MEM	CSN, MEMO, 256MB MISCL	PER320 8GB MEM	PER320 8GB MEM
Network Card	CSN, CARD, CISCO WIC-2T 2PORT SERIAL WAN CARD	PER320 NETWORK CARD	SCN, CARD, CISCO T1 DSU/CSU WAN Interface Card	SCN, CARD, CISCO T1 DSU/CSU WAN Interface Card	PER320 NETWORK CARD	CSN, CARD, CISCO WIC-2T 2PORT SERIAL WAN CARD
Power Supply	DL380 G6 POWER SUPPLY	ALCATEL 6850 POWER SUPPLY	DL380 G7 POWER SUPPLY	ALCATEL 6850 POWER SUPPLY	CISCO 3560 POWER SUPPLY	CISCO 3560 POWER SUPPLY
Racking	DL380 G6 RACK EARS	0	0	DL380 G6 RACK EARS	0	0
Rail Kits	DL380 G6/G7 RAIL KITS	0	0	DL380 G6/G7 RAIL KITS	0	0
Router	CISCO C2821	0	0	CISCO C2821	0	0
Server	PER320	DL380 G7	DL380 G7	PE2900	PER320	DL380 G6
Switch	ALCATEL 6850 SWITCH P48	ALCATEL 6850 SWITCH P48	ALCATEL 6850 SWITCH P48	ALCATEL 6850 SWITCH P48	CISCO 2960 SWITCH	ALCATEL 6850 SWITCH P48
Transceiver	ALCATEL GBIC MODULE	ALCATEL GBIC MODULE	0	ALCATEL GBIC MODULE	ALCATEL GBIC MODULE	0
UPS	TRIPP LITE UPS	HP UPS	HP UPS	HP UPS	HP UPS	HP UPS
VOX Fax	CSN, MODU, CISCO 32-CHNL VOX FAX DSP	0	0	CSN, MODU, CISCO 32-CHNL VOX FAX DSP	0	0

<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>