Create new lists from an array in Excel
Hi,
I would like help building a formula that creates a new list of values from an array containing a reference value in example below find all “a”, “b” & “c” and populate the list with the corresponding Col 2 value
e.g.
Col1 Col2 new list “a” new list “b” new list “c”
a 1 1 5 3
a 2 2 4 2
b 5 2 3
c 3 5
b 4
c 2
c 3
a 2
a 5
Thanks All
Hi,I would like help building a formula that creates a new list of values from an array containing a reference value in example below find all “a”, “b” & “c” and populate the list with the corresponding Col 2 valuee.g. Col1 Col2 new list “a” new list “b” new list “c”a 1 1 5 3a 2 2 4 2b 5 2 3c 3 5 b 4c 2c 3a 2a 5 Thanks All Read More