Hi,
I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers.
Fo example:
Sheet A (2015)
AUDI
BMW
Toyota
Ford
Volvo
Volvo
Sheet B (2016)
BMW
Citroen
BMW
BMW
AUDI
In each sheet, a manufacturer can be stated several times. I need to getdata that the manufacturer is in the list. The result would look like:
Sheet C(Overview)
BMW
Toyota
Citroen
BMW
AUDI
Ford
Volvo
As you can see,Citroen was only in sheet B and Toyota in sheet A but in the overview I know itis used un-dependent on what sheet it is in. Others were stated several times in different sheets.
Thanks.
/M
I have a document with different sheets named year (215,2016, etc). Each sheetcontain data from car manufacturers.
Fo example:
Sheet A (2015)
AUDI
BMW
Toyota
Ford
Volvo
Volvo
Sheet B (2016)
BMW
Citroen
BMW
BMW
AUDI
In each sheet, a manufacturer can be stated several times. I need to getdata that the manufacturer is in the list. The result would look like:
Sheet C(Overview)
BMW
Toyota
Citroen
BMW
AUDI
Ford
Volvo
As you can see,Citroen was only in sheet B and Toyota in sheet A but in the overview I know itis used un-dependent on what sheet it is in. Others were stated several times in different sheets.
Thanks.
/M