tabel formula

A

Adrian

Hello,
I have 2 tabels in Excel, each of them with names of societies. Certain
companies appear in both tabels, others of them appear only in one tabel.
I want to create a third tabel in which i could have all companies but i
don't want to double them,only to appear a single time.
What formula could i use?
Thanks for your support
 
O

OssieMac

Hi Adrian,

I think that the easiet way to achieve this is to copy both ranges to
another worksheet with one under the other and then use advanced filter to
produce a unique set of records. Look up advanced filter in Help. It is very
easy to use.
 
A

Adrian

"OssieMac" a scris:
Hi Adrian,

I think that the easiet way to achieve this is to copy both ranges to
another worksheet with one under the other and then use advanced filter to
produce a unique set of records. Look up advanced filter in Help. It is very
easy to use.
Click to expand...




Thank you for your advice.
It works !
 
Top