Matrix for Lego Dimensions question

MrGarner

New Member
Joined
Dec 1, 2016
Messages
5
Hi. In the Excel sheet I've linked to there are a number of rows (Lego Dimensions characters) and each has a coloured cell to denote which columns (Lego Dimensions skills) are relevant to it.

I would like to know a way to find the most efficient way of ensuring every skill is available by using the least Lego characters in the rows.

I've tried doing it manually but would prefer to find an accurate way of doing it. It would be cost saving!

https://1drv.ms/x/s!AjscKy2sME65g8V82OXkXihsw6OccA
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
I've removed the ones I already have but have realised that might not be the best way of doing it. Either way, if anyone gives me an idea to work with I can redo it.
 
Upvote 0

Forum statistics

Threads
1,214,985
Messages
6,122,605
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top