Results 1 to 5 of 5

Marking Grid Points

Threaded View

SamuelT Marking Grid Points 11-18-2008, 12:04 PM
Andy Pope Name the range... 11-18-2008, 12:12 PM
SamuelT Thanks Andy, that's working a... 11-18-2008, 12:40 PM
Andy Pope Yes. If you named the... 11-18-2008, 12:47 PM
SamuelT Great stuff. Thanks Andy -... 11-18-2008, 12:59 PM
  1. #1
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664

    Marking Grid Points

    Hi all,

    I have a worksheet ('Matrix') that has a grid that is 40 rows x 40 columns. On another sheet ('Drivers') I have a two columned table where a user is enters two numbers between (you guessed it!) 1 and 40.

    What I'm trying to do is within the grid, have a "Y" appear on the crossing point as denoted by the table. I've tried a couple of experiments with MATCH, but I'm not getting very far.

    I've attached an example document to make this a bit clearer and I've coloured the references on the 'Drivers' sheet to correspond to where they should appear on the 'Matrix' sheet.

    Sorry if that's a bit garbled. Let me know if you need any clarification.

    TIA,

    SamuelT
    Attached Files Attached Files
    Last edited by SamuelT; 11-18-2008 at 01:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1