P
puiuluipui
Stefi, can you help me with one last problem? at least i hope so....
It's about date formula...
=IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B5;"dddd");"YES";"NO")
Example:
a b c
planning! b c
1 john (ace) 11.05.2008 no john
monday
2 mary (mer) 16.05.2008 yes mary
friday
i would like formula to ignore parenthesis " (ace) ; (mer) "
in my table i will write like this :john (ace) and mary (mer), but in
database it will be without parenthesis : "john ; mary"... Can formula
extract only john or mary? ..and ignore the rest?
it is posible?
THANKS ALLOT
It's about date formula...
=IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B5;"dddd");"YES";"NO")
Example:
a b c
planning! b c
1 john (ace) 11.05.2008 no john
monday
2 mary (mer) 16.05.2008 yes mary
friday
i would like formula to ignore parenthesis " (ace) ; (mer) "
in my table i will write like this :john (ace) and mary (mer), but in
database it will be without parenthesis : "john ; mary"... Can formula
extract only john or mary? ..and ignore the rest?
it is posible?
THANKS ALLOT