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.
<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>
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>