Learn Excel - Join Values in a Matrix - Podcast 1773. You have a 5x5 Risk and Severity Matrix. Separately, there is a database of events. Each is assigned a risk and severity. Place the record number from each event in the proper box. If more than one record falls in a cell, join them with commas in between. After consulting with ExcelisFun, I went with a custom function in VBA. Can you think of a formula that wouldn't be repetitively silly?
Tags: Learn Excel - Join Values in a Matrix - Podcast 1773, Microsoft Excel, Excel, Bill Jelen, MrExcel, For each record in a database, Assign values to a 2 by 2 matrix, VBA, UDF, User Defined Function, Excel UDF that accepts a range as an argument, Why you should not merge cells in Excel, Fill in a 5x5 matrix in Excel with the record numbers that fall in each intersection, Matrix of Probability and Severity