Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Mechanicsville, Virginia, USA
    Thanked 0 Times in 0 Posts

    Arrays (Excel 2003)

    I can never get these to work <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> . I had submitted a post previously for help with this same type of array. Can't seem to get it to work on this spreadsheet. Help!

    Summary worksheet, Cell F5. It should be looking at columns F and G of the Entry worksheet.

    Please let me know what I am doing wrong this time <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Arrays (Excel 2003)

    The named ranges on the Entry worksheet (Department, Error, Pieces and Trays) all start in row 5, below the actual data, so there is nothing that matches... If you redefine them to start in row 2, you should get better results.

Posting Permissions

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