Returning a text by searching the whole workbook

  • Thread starter Thread starter Sai Krishna
  • Start date Start date
S

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
 
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...
 
Hi,

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