Suppose there is a building with 18 windows per floor.
The architect says he would like to randomly select any 4 windows per floor to be toned in a different colour.
However, there should remain at least 2 regular windows between any pair of toned windows.
How can I calculate the number of...
Hi, I wonder if anybody could help with this one:
You have a table with invoice numbers and amounts by vendor. The job is to add a "User" column into this table using vlookup and/or other excel functions showing User1/User2/User3 linked to each vendor name, when you have a reference table on a...
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.