Hi
I have data in 3 columns as shown in the image below.
Now what I am trying to do is to find the difference between dates for the first time a code occurs and the last time it occurs.
For example the code "13193875" occurs 3 times first on 4-march-08 and last on 19-march-08. The required answer in this case is 15.
Thanks for your help.
I have data in 3 columns as shown in the image below.
Now what I am trying to do is to find the difference between dates for the first time a code occurs and the last time it occurs.
For example the code "13193875" occurs 3 times first on 4-march-08 and last on 19-march-08. The required answer in this case is 15.
Thanks for your help.