Name multiple instances of a value.

[Ody55ey]

I could just look this up, but I'll be lazy.
I want to name multiple instances of a value.


Ref.No - Date - Instance
123 01/01/2009 1st
123 06/01/2009 2nd
122 07/02/2009 1st


Column "Instance" to look at "Ref.No" and "Date", giving the result of "1st instance", etc. (Using dates order)

I've tried arrays of Match and count, but I'm stuck.

[martindwilson]

well the answer is........
nope too lazy to type sorry

[Ody55ey]

Thanks, I'll try another site.

[mudraker]

With the OP's attitude I have closed this thread