Hi

If I have 2 columns of numbers (A and B), how do I filter based on values of A between 0 and 5 and then pick the row with the maximum value of B in that range. This row then need to be copied to a new location (columns C and D) and the whole process repeated for additional ranges of A (5 to 10), (10 to 15), (15 to 20) etc to build a new series of data in C and D.

Cheers

Shaun.