Thread: Redundant data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ale ale is offline
external usenet poster
 
Posts: 14
Default Redundant data

Hi!

I need to remove redundant/common data from two different column.
For example, I have columns A and B as follows:

A B
1 7
3 9
4 3
7 1
8

and I'd like to have two more columns, like C and D, containing:

C D
4 9
8

How is it possible to do that?

Thanks a lot,

ale