Hi! I was wondering if someone could help me. I'm trying to create a matrix like this:
http://www.robertsongeoconsultants.c...sues/fig3c.jpg
I have a table like this below.
Concept ID Risk Number AB1 3 AB2 4 AB3 3 AB4 5 AB5 4 AB6 3 AB7 4
I was wondering is there a function that could take the Risk Number of 3 and produce a result of (AB1, AB3, AB6)
or like a risk number of 4 and the function produces (AB2, AB5, AB7)
So it produces all the results in a list with commas or just with a space.
Thanks so much if anyone could help!
Bookmarks