[absthechatter]

I can add and use auto filter(!!) and I can use a formula to determine the ranked position, but can I do them both together, so when filtered, only the remaining entries are ranked as though the non filtered options do not exist? Thought I may be able to do it using the subtotal function, but cannot get anything working using rank as well.

Any help much appreciated.

Many thanks


Abs