Hi all,
Let me describe my project. I am trying to write a macro. Which will calculate a Iron's recovery time.
One ID has 6 or more sample points for the same date.
I would like to ID and identify sample point which has Iron value more than x, and count how many days will take to reach the Iron value y.
Example:
ID point Iron Date
7361348 1 369 17/03/2008 00:00
7361348 1 309 19/03/2008 00:00
7361348 1 152 20/03/2008 00:00
7361348 2 306 20/03/2008 00:00
7361348 2 242 20/03/2008 00:00
7361348 2 652 20/03/2008 00:00
7361348 3 471 20/03/2008 00:00
7361348 3 243 20/03/2008 00:00
7361348 3 276 20/03/2008 00:00
7361348 4 364 20/03/2008 00:00
7361348 4 157 20/03/2008 00:00
7361348 4 351 20/03/2008 00:00
7361348 5 533 20/03/2008 00:00
7361348 5 262 20/03/2008 00:00
7361348 5 652 21/03/2008 00:00
7361348 6 123 20/03/2008 00:00
7361348 6 62 20/03/2008 00:00
7361348 6 134 20/03/2008 00:00
Example threshold x 500 threshold y 270
7361348 5 533 20/03/2008 00:00
7361348 5 262 21/03/2008 00:00
it took one day.
I would like to take all recovery dates and make it average.
Your ideas will be highly appreciated.
Bookmarks