Hi everyone,
You've always been so knowledgeable and expert and I'd love to draw on the communities wisdom again.
I'm not really even sure how to title what I am hoping to make Excel do or how to search for help.
Imagine a Risk Assessment - each risk ID has an impact and a likelihood.
So each row has 3 numbers - an ID, an Impact and a Likelihood.
What I want to do is plot the ID's (rows) on a table.
So in a simple example, the table is 3x3.
So if ID 1 has an Impact number of 1 and a likelihood number of 1, it appears in the bottom left box of the table - plotted 1 - 1.
But, if 3 ID's all also have 1 and 1, then they would also need to be displayed in that box, separated by a comma.
I've demonstrated this in the attached sheet, but what I can't work out is whether this could be automated in some way?
To be honest, I've no idea where even to start with trying to address it.
Thanks so much everyone for any ideas you've got.
Appreciate it all.
Chris
Bookmarks