Hi!

I do work with some sampling, and i do need to filter some data. My data set looks like this:

Sample point Date Value
A xx.xx.xxxx 10
B xx.xx.xxxx 5
C xx.xx.xxxx 15
A yy.yy.yyyy 12
B yy.yy.yyyy 10
A zz.zz.zzzz 21
.... ............. .....

I would now get the Excel to find the samples from the last ten dates of this data set, and the filter out how many time sample point A exceeds 5, 10 and 20.

Any good ideas of how i can this?