6x6

1. 2D Array in a 2D array

Hi, I'm wondering if it's possible to have a 2x2 array of random values inserted into the centre of a 6x6 array of zeros. 0,0,0,0,0,0 0,0,0,0,0,0 0,0,x,x,0,0 0,0,x,x,0,0 0,0,0,0,0,0 0,0,0,0,0,0 I also need to be able to extract the 2x2 array from the 6x6 array for use later in the code...
2. Have Excel ignore numbers in formula that are only a description.

Hi Everyone, I have a =IF formula that works great thanks to people here, the problem I would like to solve is a description issue, the example is 6x6 or 4x6 etc. Here is my formula =IF(M12=4,N12*1.5709*4.25,IF(M12=5,N12*2.4545*4.25,IF(M12=6,N12*3.5345*4.25,""))) I need as an example...
3. Unique cell fill formula or vba

I would like to have a 6x6 range (eg: E3:J8) where some cells are filled black, and some are filled white ... I would, however, like each corner cell to have no choice but to be black. To produce multiples of these 6x6 ranges on the one A4 page, I could write a basic formula into each cell...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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.

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

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