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.