Hi,
I'm not 100% certain I am using the proper function, thus the "possibly" in my title.
I have 2 sheets. Sheet two has a list of people in column A (a1:a25)and through the spreadsheet from a3 - z3 there are names of companies. For each employee, I have typed a * where they are working that day.
For each employee, I have 4 working in column c, 4 in colmn d etc.
On sheet 1 I have
A B C D
Row 5 Emp 1, Emp 2, Emp 3 Emp4
My question is... How do I do a logical test to see
Which emp1 on sheet 2 is working for company in column c row 4
Which emp2 working for company in column c row 10
if I have emp3 working for company in column c row 15
if I have emp4 working for company in column c row 22
Then put the employee name in row 6a, 6b, 6c and 6d
I looked at the countif and although that seems to return a value, HOW can i have it put the persons name in and not a yes or no.
Here is the command I was trying..
=IF('Second Sheet'=(COUNTIF(C5:C25,"*"),"c5:c25","0")
And of course, there is an error.. I know I am missing something or I am not using the correct operand. If, If then, conditional if?
What i want is:
If there is a star in column c, in this range c2:c10 then put the persons name that is corresponding in the space on sheet 1, otherwise, move on till you find a * and then put that corresponding name in it.
Then do the dame but for c11:c20
Hope this makes sense!
Harold
I'm not 100% certain I am using the proper function, thus the "possibly" in my title.
I have 2 sheets. Sheet two has a list of people in column A (a1:a25)and through the spreadsheet from a3 - z3 there are names of companies. For each employee, I have typed a * where they are working that day.
For each employee, I have 4 working in column c, 4 in colmn d etc.
On sheet 1 I have
A B C D
Row 5 Emp 1, Emp 2, Emp 3 Emp4
My question is... How do I do a logical test to see
Which emp1 on sheet 2 is working for company in column c row 4
Which emp2 working for company in column c row 10
if I have emp3 working for company in column c row 15
if I have emp4 working for company in column c row 22
Then put the employee name in row 6a, 6b, 6c and 6d
I looked at the countif and although that seems to return a value, HOW can i have it put the persons name in and not a yes or no.
Here is the command I was trying..
=IF('Second Sheet'=(COUNTIF(C5:C25,"*"),"c5:c25","0")
And of course, there is an error.. I know I am missing something or I am not using the correct operand. If, If then, conditional if?
What i want is:
If there is a star in column c, in this range c2:c10 then put the persons name that is corresponding in the space on sheet 1, otherwise, move on till you find a * and then put that corresponding name in it.
Then do the dame but for c11:c20
Hope this makes sense!
Harold