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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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,215,674
Messages
6,126,144
Members
449,294
Latest member
Jitesh_Sharma

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