Thank you very much Max. I will give it a try. So If I have understood
correctly, I type the short formula in AF2, leave AF1 empty; type the long
formula in AG2, highlight both AF2 and AG2 and copy down the column (it will
be a max of 50); is that correct?
It now leaves me with the (possible?) automated SUM calculation in column Y,
before I can try yours in my recap table.
Thank you very much for your time and I hope you have a good day.

"Max" wrote:

Here's some thoughts for the 2nd Q in your post, ie a simple play to
dynamically extract col Y's interspersed results directly into col AG, all
neatly bunched at the top as desired

In AF2: =IF(Y2="","",ROW())
Leave AF1 empty

In AG2:
=IF(ROWS($1:1)COUNT(AF:AF),"",INDEX(Y:Y,SMALL(AF: AF,ROWS($1:1))))
Select AF2:AG2, copy down to cover the max expected extent of col Y, say
down to AG200? AG2 will return the required results from col Y, all neatly
packed at the top. Minimize/hide away col AF.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---