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

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.

--
Regards,

OssieMac


"Adrian" wrote:

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

--
Regards,

OssieMac




Thank you for your advice.
It works !