+ Reply to Thread
Results 1 to 6 of 6

Match Column and Row with diagonal values

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Match Column and Row with diagonal values

    Hi,
    I want to see the information of column J to V* in the columns B to H with a formula.
    The problem is the information in column J to V* is diagonal to the the columns and rows in B to H

    See attachment that would make it more clear (is a sample). In sheet 2 I also created the outcome but then with paste value/transpose.

    What I also would prefer is that It will be done with a match formula that if I change a name in both sheets the other sheet adopts this change

    * Only the Volume Column in the columns J to V
    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Match Column and Row with diagonal values

    Hi,

    One way in B2 copied across and down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Match Column and Row with diagonal values

    Hi Thanks A lot,
    One question if I copy the formulas to totally down to 19 January then I see in in row 5 to 19 the same amount, in this fields I would rather see a 0.
    Is this possible

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Match Column and Row with diagonal values

    Hi,

    Move your dates to K1, N1, Q1 etc. and use

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Match Column and Row with diagonal values

    you could use sumproduct if your workig with numbers

    try this

    Please Login or Register  to view this content.
    (and switch your 0s to view on in excel options)
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  6. #6
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Re: Match Column and Row with diagonal values

    Thanks a lot! Problem solved

+ 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