+ Reply to Thread
Results 1 to 5 of 5

Marking Grid Points

Hybrid View

  1. 11-18-2008, 12:47 PM #1
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    Yes.

    If you named the range of values in column C MYVALUES use this new formula on the Matrix sheet

    =SUMPRODUCT((MYROW=$A2)*(MYCOL=B$1)*MYVALUES)
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  2. 11-18-2008, 12:59 PM #2
    SamuelT
    SamuelT is offline
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664
    Great stuff. Thanks Andy - much appreciated.

    Solved!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1