Hello
I am looking for an excel formula to help me with data sorting, please see attached excel example;
- the data table on the left is produced and dumped from internal software
- what i am hoping to do is create a formula, which based on the document #'s lists the respective data dates along the same line
- example for document T1; in cell I2 the formula would look for the document #, and if it contains IFR within the transmittal number (on the table at the left), it would produce IFR issued date (from table at the left). Thus the value of I2 would be 2009-08-09.
- value in K3 would be 2009-01-09, etc.
If anyone could provide some advise or possible other options for sorting the date, it would be greatly appreciated.
Thanks
I am looking for an excel formula to help me with data sorting, please see attached excel example;
- the data table on the left is produced and dumped from internal software
- what i am hoping to do is create a formula, which based on the document #'s lists the respective data dates along the same line
- example for document T1; in cell I2 the formula would look for the document #, and if it contains IFR within the transmittal number (on the table at the left), it would produce IFR issued date (from table at the left). Thus the value of I2 would be 2009-08-09.
- value in K3 would be 2009-01-09, etc.
If anyone could provide some advise or possible other options for sorting the date, it would be greatly appreciated.
Thanks