Apr 3, 2014
I have IDs in the first column of an excel chart. After that I have three more columns, being date of test, type of test (start, 3 months, 6 months, 9 months, finish), and lastly the result for the test.
View 1 Replies
Right now, the same IDs are listed multiple times for different results, so for example:
ID | Date | Type | Result
27 | 3/27 | Start |8.3
27 | 6/27 |3 Mon |7.9
27 | 9/27 |6 Mon |7.4
27 | 12/3 |9 Mon |7.2
27 | 3/27 | FINISH |6.5
What I need is the following layout:
ID | Start | Date | 3 Months | Date | 6 Months | Date | 9 Months | Date | Finish | Date
ID is only shown at left, and the values for the test result and corresponding dates are shown in their respective columns.
I tried to do an IF function with a LOOKUP inside, and it worked originally, but when I add more values for the same ID to the original column, it only shows the latest date, and only gives that result.