K
kevindict
I have a worksheet that contains three columns of data. All of the data
are people's names and some are repeated in multiple columns and some
are not. What I'd like to do is use a function to generate a fourth
column that contains a list of individuals from those three columns
without containing any repeats or omitting any individuals. SO.
MARK JONES TIM CAROTHER MARK JONES
ANN MAKER ANN MAKER ALBERT SMITH
Would turn in to:
MARK JONES
ANN MAKER
TIM CAROTHER
ALBERT SMITH
I know how to do this with a single column using a countif function, I
just cant seem to do it with a multiple coleumn range.
Thanks,
Kevin
are people's names and some are repeated in multiple columns and some
are not. What I'd like to do is use a function to generate a fourth
column that contains a list of individuals from those three columns
without containing any repeats or omitting any individuals. SO.
MARK JONES TIM CAROTHER MARK JONES
ANN MAKER ANN MAKER ALBERT SMITH
Would turn in to:
MARK JONES
ANN MAKER
TIM CAROTHER
ALBERT SMITH
I know how to do this with a single column using a countif function, I
just cant seem to do it with a multiple coleumn range.
Thanks,
Kevin