+ Reply to Thread
Results 1 to 2 of 2

"Twin" grids

  1. #1
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    "Twin" grids

    This is a bit complicated to explain...

    Let's say we have two tables: A1-D5 and F1-I5.
    Both tables' first column and row are marked with letters or numbers, so that every cell inside B2-D5 and G2-I5 have their "coordinates".
    They are the same in both grids, for example, 123-ABC, 123-ABC.
    (A1 and F1 are empty).

    Now, I'd like to set a "connection" between these two grids, so that every cell refers to it's "twin" cell in another grid, which takes the same coordinates.

    Let's say, we need the double values in the right grid (if C5 is 8, H5 would be 16) but without determining each cell's reference. So, I need a universal formula, the same one in all cells, which will check out it's own position inside the grid, find the same position in the other grid and calculate it's double value.

    I'd really appreciate your help!

    Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: "Twin" grids

    In F1 and copy right and down, =2*A1
    Entia non sunt multiplicanda sine necessitate

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1