Returning a text by searching the whole workbook

[Sai Krishna]

Hi friends,

I have a master sheet containing the names of employees in one column and
their salaries in the adjacent column.

In the other sheets, I have the names of these very employees in specific
sheets which is named for each project they are working in.

Now not all employees are assigned a project.

Now I need to take out names of those employees in the master sheet whose
name does not figure in the other sheets, let us say project sheets.

I need to display this is a separate worksheet. The idea is to know who are
those associates who have not been assigned a project and thus available as a
free resource.

regards
krishna

 

[Sean Timmons]

If the employee names are in column A and the master worksheet name is in A2,
then:

=countif(sheet2!A:A,A2)+countif(sheet3!A:A,A2)+countif(sheet4!A:A,A2)

etc...

replace your sheet names for sheet 2 et. al.

Works if you don't have too many sheets...

 

[Sai Krishna]

Hi,

thanks for the tip. It worked. I had around 12 sheets and it returned great.
regards
krishna