+ Reply to Thread
Results 1 to 8 of 8

How to populate names in a 16-box grid from a list of names and two variables columns

  1. #1
    Registered User
    Join Date
    06-06-2019
    Location
    Sioux Falls, SD
    MS-Off Ver
    2016
    Posts
    4

    How to populate names in a 16-box grid from a list of names and two variables columns

    I need to construct a formula to populate a basic 16 box grid from a simple spreadsheet with names and two variables/categories (i.e. the X and Y axes of the 16 box grid).

    16 box to populate.PNG
    Attached Files Attached Files

  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: How to populate names in a 16-box grid from a list of names and two variables columns

    Is this the desired result?

    B
    C
    D
    E
    F
    G
    H
    2
    Unsatisfactory Performance Performing Essential Functions Performing Above Expectations Performance Excellence
    3
    0 (0%) 0 (0%) 2 (5.4%) 0 (0%)
    4
    >= 110% Name 6
    Name 24
    C4: {=catif(('List View'!$B$2:$B$38 = C$2) * ('List View'!$C$2:$C$38 = $B4), 'List View'!$A$2:$A$38, CHAR(10))}
    5
    0 (0%) 1 (2.7%) 8 (21.6%) 0 (0%)
    6
    100 to < 110% Name 35 Name 5
    Name 10
    Name 12
    Name 14
    Name 23
    Name 25
    Name 30
    Name 34
    7
    0 (0%) 2 (5.4%) 5 (13.5%) 2 (5.4%)
    8
    90 to < 100% Name 31
    Name 36
    Name 2
    Name 4
    Name 20
    Name 21
    Name 27
    Name 15
    Name 28
    9
    0 (0%) 1 (2.7%) 13 (35.1%) 3 (8.1%)
    10
    < 90% Name 18 Name 3
    Name 7
    Name 8
    Name 11
    Name 13
    Name 16
    Name 17
    Name 19
    Name 26
    Name 29
    Name 32
    Name 33
    Name 37
    Name 1
    Name 9
    Name 22
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-06-2019
    Location
    Sioux Falls, SD
    MS-Off Ver
    2016
    Posts
    4

    Re: How to populate names in a 16-box grid from a list of names and two variables columns

    That looks great! Unfortunately I'm not getting the formula to work on my spreadsheet even after unmerging and setting up cells exactly like yours. Any ideas why it's still not populating?

    Attachment 627369

  4. #4
    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: How to populate names in a 16-box grid from a list of names and two variables columns

    It's a user-defined function:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-06-2019
    Location
    Sioux Falls, SD
    MS-Off Ver
    2016
    Posts
    4

    Re: How to populate names in a 16-box grid from a list of names and two variables columns

    Thank you shg! Do I just add this as a module and save as a macro workbook? It still doesn't seem to be working. I apologize but this is a bit over my head. Anything else I should be doing?

  6. #6
    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: How to populate names in a 16-box grid from a list of names and two variables columns

    1. Copy the code from the post
    2. In Excel, press Alt+F11 to open the Visual Basic Editor (VBE)
    3. From the menu bar in the VBE window, do Insert > Module
    4. Paste the code in the window that opens
    5. Press Alt+Q to close the VBE and return to Excel

    The formula shown is an array formula, which MUST be confirmed with Ctrl+Shift+Enter, not just Enter. Paste the formula in the formula bar, sans curly braces, press and hold the Ctrl and Shift keys, then press Enter. You'll know you did it correctly if those curly braces appear; you cannot type the braces manually.

  7. #7
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: How to populate names in a 16-box grid from a list of names and two variables columns

    Another formula base.
    Please try at C3 and copy across the table

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

  8. #8
    Registered User
    Join Date
    06-06-2019
    Location
    Sioux Falls, SD
    MS-Off Ver
    2016
    Posts
    4

    Re: How to populate names in a 16-box grid from a list of names and two variables columns

    THANK YOU THANK YOU THANK YOU!!! This is exactly what I was looking for. I appreciate it so much!!!!!!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I need to put 10 columns of names and scores into one list only with unique names?
    By slock92 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2019, 09:06 AM
  2. populate unique list of names from a column
    By Excelski in forum Excel General
    Replies: 2
    Last Post: 06-15-2017, 10:02 AM
  3. [SOLVED] Populate combobox with names list
    By Axmed.cm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2015, 10:35 AM
  4. [SOLVED] Draw random names from list and then remove, carry on till no names left in list
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:14 PM
  5. Replies: 2
    Last Post: 01-20-2012, 12:51 PM
  6. Populate List Names
    By gmazza76 in forum Excel General
    Replies: 5
    Last Post: 09-29-2011, 03:40 PM
  7. [SOLVED] List box: Populate with Range Names
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2005, 07:05 PM

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