grid

  1. J

    Using Vlookup In a Range

    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...
  2. C

    random unique numbers/ names put into a grid - help needed

    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...
  3. H

    How to create a macro to automatically fill in a grid

    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...
  4. K

    Grid Formula: Index, Choose & Match function (utilizing named arrays) across multiple sheets possible

    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...
  5. A

    Finding numbers within a range on a x,y grid

    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...
  6. J

    Table Formatting

    Amateur question: How do I get rid of the standard, border-free, grid lines in my spreadsheet even though they don't appear when I print? Thanks.
  7. R

    random number generator

    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'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