D
david.maddern
I am attempting to create a worksheet that will search a
table of 2 columns (one date one name) for a certain date.
Once it finds the date it will take the corresponding name
and populate a new table (a calendar) with the name. There
can be more than one instance of a name on a dat (ie John
Doe and Susan New can both have a date of 6/4/04). I have
been able to get the first name to populate properly by
using the IF function, but it will not populate the
remaining names for that date.
Any suggestions are appreciated.
David
table of 2 columns (one date one name) for a certain date.
Once it finds the date it will take the corresponding name
and populate a new table (a calendar) with the name. There
can be more than one instance of a name on a dat (ie John
Doe and Susan New can both have a date of 6/4/04). I have
been able to get the first name to populate properly by
using the IF function, but it will not populate the
remaining names for that date.
Any suggestions are appreciated.
David