tabel formula

[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

 

[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.

 

[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.

Thank you for your advice.
It works !