G
Guest
Hi I am looking for the best formula to return a value depending on a couple
of arguements.
I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..
I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05
Thanks in advance
of arguements.
I have two columns one with activity , one with a date - say a and b for
arguments sake.. column a may have: 1/1/05 , 2/1/05 , 3/1/05, 4/1/05 , 5/1/05
where column b may have: phone call , meeting , email , meeting, email..
I wouldlike to have a formual the shows the last date we had a meeting.. in
this case 4/1/05
Thanks in advance