Hello ,maybe the title is not well described.
In the first sheet, in the column A, I have a list of companies + services hired in the same cell.
In the second sheet, I have in the column A, each company, and in the row 1 , all the services.
What I need to do in sheet 2,exactly from cell b2, fill each company with a tick or a cross if they have the service or not. I knew there was a way with count*find , but cant manage to do it.
helppppp
thank you !
In the first sheet, in the column A, I have a list of companies + services hired in the same cell.
In the second sheet, I have in the column A, each company, and in the row 1 , all the services.
What I need to do in sheet 2,exactly from cell b2, fill each company with a tick or a cross if they have the service or not. I knew there was a way with count*find , but cant manage to do it.
helppppp
thank you !