Data Validation

  • Thread starter Thread starter kevindict
  • Start date Start date
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
 
Kevin,

One way would be to put them in one column (paste one under another), sort
it (putting duplicates next to each other), then, presuming the single
column is A and starts in A2, put this in B2 and copy down (temporarily):

=IF(COUNTIF($A$1:A2,A2)=1,A2,#N/A)

Now select column B, Edit - Goto - Special - Formulas - Errors (only --
don't check other three).

Edit - Delete - Entire Row.
 
Back
Top