6x6

  1. B

    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. M

    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. P

    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...
Master Excel Bundle

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.
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
Top