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
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
Is this the desired result?
B C D E F G H 2Unsatisfactory Performance Performing Essential Functions Performing Above Expectations Performance Excellence 30 (0%) 0 (0%) 2 (5.4%) 0 (0%) 4>= 110% Name 6
Name 24C4: {=catif(('List View'!$B$2:$B$38 = C$2) * ('List View'!$C$2:$C$38 = $B4), 'List View'!$A$2:$A$38, CHAR(10))} 50 (0%) 1 (2.7%) 8 (21.6%) 0 (0%) 6100 to < 110% Name 35 Name 5
Name 10
Name 12
Name 14
Name 23
Name 25
Name 30
Name 34 70 (0%) 2 (5.4%) 5 (13.5%) 2 (5.4%) 890 to < 100% Name 31
Name 36Name 2
Name 4
Name 20
Name 21
Name 27Name 15
Name 28 90 (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 37Name 1
Name 9
Name 22
Entia non sunt multiplicanda sine necessitate
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
It's a user-defined function:
Please Login or Register to view this content.
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?
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.
Another formula base.
Please try at C3 and copy across the table
Formula:Please Login or Register to view this content.
THANK YOU THANK YOU THANK YOU!!! This is exactly what I was looking for. I appreciate it so much!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks