Ségolène has attended:
Excel Advanced course
Excel
I have two sheets with company names. I want to identify in sheet 2 the companies that are in sheet 1. I used ctrl f, and searched manually but i am sure there is a function to do that. Which one is it?
Is there a terminal in excel or applications to do this?
thank you
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel
Hi Ségolène,
I hope you are fine and thank you for the forum question.
You have different options.
You can use a Countif to do what you want.
If for example the company names on sheet 1 is in the range A2:A300 and your company names are in the same range on sheet 2.
In a new column on sheet 2, select a cell in the same row as your first company name. Type =Countif('sheet 1'!$A$2:$A$300,A2)
Copy down the formula for all rows on sheet 2.
If the countif returns 1 you have the company name on both sheets, if it returns 0 you only have the company name on sheet 2.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
