Array formulae/macro? Counting datasets -

[ad9051]

My knowledge of excel is mediocre/good, however when it comes to using array formulae I'm a little bit of an amateur. The problem I have is that I receive hundreds of datasets every day, it would be very useful to be able to count the size of these datasets (they range from 2 - 30 pieces of data in size.) Also I would like to return the size of the dataset in the same row where the data rank = 1. Note this is not always the top piece of data.

It is best to take a look at the example spreadsheet provided.

If anyone could provide any assistance it would be greatly appreciated.

Merry Xmas

Ad