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.

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