Thread: fORMULA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phxlatinoboi® Phxlatinoboi® is offline
external usenet poster
 
Posts: 16
Default 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