Results 1 to 10 of 10

Create matrix from larger table

Threaded View

  1. #1
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,316

    Create matrix from larger table

    Hi Guys,

    For fun I've created this Round Robin schedule for up to 50 players based on a Berger Table.

    The next step would be to create a matrix on Scoresheet Columns H & I with the results of the calculation on Berger_Table sheet.

    Using VBA (which I've included for reference) it is easy to create the matrix but I was wondering if the same can be done using formulea.

    Columns K & L are the results I'm looking for, Columns M & N are the VlookUps for these numbers based on Names list.

    So changing the number of Players and clicking button will produce new matrix for reference.

    Since I'm not a formula guy any suggestions or improvements on the formulas used so far is greatly appreciated.

    PS: Only use even number of players.

    Greetz

    Rudi
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] create vertical table of specifc cells in correlation matrix
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2017, 10:30 AM
  2. Should I use a pivot table to create a matrix?
    By dazbear in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-13-2015, 02:47 PM
  3. Create a new table (or matrix) from an exported set of data from a website.
    By dherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 11:19 AM
  4. Create matrix from a "table" by condition on lacking date-value
    By Cedicon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 02:45 PM
  5. Help to Create Matrix table.
    By sem in forum Excel General
    Replies: 8
    Last Post: 07-19-2011, 02:53 PM
  6. Create sublist from larger list
    By writeguy37 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-27-2008, 11:52 AM
  7. Invert a matrix larger than 52 x 52 using MINVERSE
    By W0PSI in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 11:55 AM

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