A
Asoka Walpitagama - Brandix College IT
In the following data set I need to fill the 'START DATE' column (F) with the
dates
( in columns B - E ) where the first number appears as shown below
Eg. CODE 1 will have 3-Jan-09 because the first number (600) appears on D
col. where the date is 3-Jan-09
A B C D E
F
1-Jan-09 2-Jan-09 3-Jan-09 4-Jan-09 START DATE
CODE 1 600 700 3-Jan-09
CODE 2 - 400 333 - 2-Jan-09
CODE 3 - - - 232 4-Jan-09
CODE 4 222 - 454 4545 1-Jan-09
CODE 5 - 333 - - 2-Jan-09
CODE 6 - - 444 2323 3-Jan-09
dates
( in columns B - E ) where the first number appears as shown below
Eg. CODE 1 will have 3-Jan-09 because the first number (600) appears on D
col. where the date is 3-Jan-09
A B C D E
F
1-Jan-09 2-Jan-09 3-Jan-09 4-Jan-09 START DATE
CODE 1 600 700 3-Jan-09
CODE 2 - 400 333 - 2-Jan-09
CODE 3 - - - 232 4-Jan-09
CODE 4 222 - 454 4545 1-Jan-09
CODE 5 - 333 - - 2-Jan-09
CODE 6 - - 444 2323 3-Jan-09