|
fORMULA
I need help with an "if" formula. I have a spreadsheet that in column a it
lists the employee's name and then in column b it lists the date the employee was at work. On a different spreadsheet i have listed a row of scheduled days of work. I would like to have on this spreadsheet to make an X if the employee has that date next to the name. How can I do this? Cooley, Arminda 03/03/08 Cooley, Arminda 03/04/08 Cooley, Arminda 03/05/08 Cooley, Arminda 03/06/08 Cooley, Arminda 03/10/08 Cooley, Arminda 03/11/08 Cooley, Arminda 03/12/08 Cooley, Arminda 03/13/08 Cooley, Arminda 03/14/08 Cooley, Arminda 03/15/08 Cooley, Arminda 03/17/08 Cooley, Arminda 03/18/08 Cooley, Arminda 03/19/08 Cooley, Arminda 03/20/08 Cooley, Arminda 03/21/08 Cooley, Arminda 03/24/08 Cooley, Arminda 03/25/08 Cooley, Arminda 03/26/08 Cooley, Arminda 03/27/08 |
fORMULA
Hi,
Use this formula in column C. =IF(MATCH(B1,Sheet2!$A$1:$A$3,0)0,"X","NotPresent ") where 1) Column B contains dates. 2) Column A of Sheet2 contains list of scheduled days. Now, you may have to change the formula as per no of days in your list. --Parag "Phxlatinoboi®" wrote: I need help with an "if" formula. I have a spreadsheet that in column a it lists the employee's name and then in column b it lists the date the employee was at work. On a different spreadsheet i have listed a row of scheduled days of work. I would like to have on this spreadsheet to make an X if the employee has that date next to the name. How can I do this? Cooley, Arminda 03/03/08 Cooley, Arminda 03/04/08 Cooley, Arminda 03/05/08 Cooley, Arminda 03/06/08 Cooley, Arminda 03/10/08 Cooley, Arminda 03/11/08 Cooley, Arminda 03/12/08 Cooley, Arminda 03/13/08 Cooley, Arminda 03/14/08 Cooley, Arminda 03/15/08 Cooley, Arminda 03/17/08 Cooley, Arminda 03/18/08 Cooley, Arminda 03/19/08 Cooley, Arminda 03/20/08 Cooley, Arminda 03/21/08 Cooley, Arminda 03/24/08 Cooley, Arminda 03/25/08 Cooley, Arminda 03/26/08 Cooley, Arminda 03/27/08 |
fORMULA
=IF(ISNUMBER(MATCH(B1,Sheet2!$A$1:$A$3,0)),"X","")
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Phxlatinoboi®" wrote in message ... I need help with an "if" formula. I have a spreadsheet that in column a it lists the employee's name and then in column b it lists the date the employee was at work. On a different spreadsheet i have listed a row of scheduled days of work. I would like to have on this spreadsheet to make an X if the employee has that date next to the name. How can I do this? Cooley, Arminda 03/03/08 Cooley, Arminda 03/04/08 Cooley, Arminda 03/05/08 Cooley, Arminda 03/06/08 Cooley, Arminda 03/10/08 Cooley, Arminda 03/11/08 Cooley, Arminda 03/12/08 Cooley, Arminda 03/13/08 Cooley, Arminda 03/14/08 Cooley, Arminda 03/15/08 Cooley, Arminda 03/17/08 Cooley, Arminda 03/18/08 Cooley, Arminda 03/19/08 Cooley, Arminda 03/20/08 Cooley, Arminda 03/21/08 Cooley, Arminda 03/24/08 Cooley, Arminda 03/25/08 Cooley, Arminda 03/26/08 Cooley, Arminda 03/27/08 |
| All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com