M
Matt
I need to create a list of unique values from a range of columns. For
example, say Columns E - G are as follows:
E F G
Bob Dave Bill
Rick Steve Dave
Steve Rick Fred
Bill Joe Steve
I would end up with one column with the unique names:
Bob
Rick
Steve
Bill
Dave
Joe
Fred
If it is possible, I would like to have the Unique list in a separate sheet,
update automatically and not use a Macro (VBA). Is this possible?
example, say Columns E - G are as follows:
E F G
Bob Dave Bill
Rick Steve Dave
Steve Rick Fred
Bill Joe Steve
I would end up with one column with the unique names:
Bob
Rick
Steve
Bill
Dave
Joe
Fred
If it is possible, I would like to have the Unique list in a separate sheet,
update automatically and not use a Macro (VBA). Is this possible?