I am trying to use a vlookup for two cells whose data are in a range of cells. The grid is in a range for weight and miles.
<tbody>
Weight
1000
1100
1200
1300
1400
1500
1600
1700
Miles
1099
1199
1299
1399
1499
1599
1699
1799
1
50
757
810
862
915
967
1019
1071
1124
51
100
786
841
896...
I am doing a cow patty drop for my local non-profit community group. We are selling tickets (numbered 101-676) for the event. In order to show who's name ends up where in the tennis court that will be marked in a 24 x 24 grid, I would like to show each ticket number (or preferably the...
I am trying to build a holiday tracker. I need to have a worksheet that, on the first tab, allows the user to fill in details such as:
name:
day:
month:
I will then have 12 tabs with each month of the year.
Each tab will have a grid with 1-31 (or however many days are in that month) at the...
Below is my formula. Several of Aladdin's and Domenic's posts inspired this.
What I was trying to accomplish:
Create a grid formula that would allow me to find a specific value at a given point in time based on user defined inputs.... but across multiple sheets.
In my case, I've written a...
Hi there,
I have a list of places each with a grid reference (longitude / latitude). They are not arranged in any order. I am given a starting grid reference and need to select a place at random that is within a specified distance (this is given in the units of the grid).
I see the steps as...
I have 4 names, and a grid of 100 boxes. I need those 4 names randomly deposited in the 100 boxes, making sure each name is displayed an equal number of times (25 each) Is there an Excel formula to compute this?
Thanks - rktucson
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.