Dan/Chris/Dave,

Thanks for your help and suggestions, it sounds like I should research the other ranking functions but for the meantime (I have a deadline which is due in about 2...

Thank you for the for the tip, I did look briefly at these functions but they seem to continue the number series across each window ... is it possible to...

My apologies again, I meant to have different amounts on each row (being a bit hasty), but also for arguments sake I've put in an additional column which contains data...

Hi Dan,

Apologies, my OP is a little unclear!

What I would like is to be able to generate row numbers that are applied through a 'window' which views the sample data...