Thank you very much for your reply - which does work in the sernerio I have given.
Where the resulting address from =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0),COLUMN(Latest2),4,1) is in c57 - address = k7
and the result of =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0)-1,COLUMN(Latest2),4,1) is in C56 - address = K6
(Your formula) gives a result of Zero (which is correct)
When I come to get the next Cell address reference using the new found address references the formula looks like this:-
The answer will be place in c58
=ADDRESS(ROW(C57:K57)+MATCH($V$77,C57:K57,0),COLUMN(C57:K57),4,1) - I don't know if this is correct but it seems to be take the cell ref as c57 and not as the address reference in its contents which is K7.
Unfortunately the Named Rages (columns) are also in C,K,S,AA,AI & AQ.
Please consider the following:-
K6, K7 ..............................................................K15 the cells in a named column range being filled as below respectively.( I have placed it in a row to save space in this reply - having tried it the other way first)
11,17,23,20,19,14,17,5,30,49,25,17,23,45,32,15 and followed by "x" - 57 empty cells as they haven't been filled with results yet (the list is made up for testing purposes - anyway)
What I am trying to do:-
find the address of the first number starting with 1 (which in this case is 11 in K6)
Find the next number starting with 1 which is 17 in K7
Count the numbers between and store the result in the first empty call in a Named range(Column named "Results1") which at the moment could be placed any where on the worksheet.
The process is then repeated finding the next address with the contents, being a number starting with 1 in this case 14 in K11.
Count the cells containg numbers between K7 & K11 and store it in the next empty cell in column range named Results1
Followed by the count between K12 and K17 and so on.
Please Note it is advisable and/or easier to have the 6 Named ranges altogether to achieve my objective either as seperate named ranges (columns) say in column a,b,c,d,e,f - or putting then in a single array A6:F57 (& named all_results) - I would be more than happy to experiment with this, since the over all objective is for me to become a lot, lot more familiar and hopeful a lot, lot better at using Excel in as many ways as I can.
I am hoping that perhaps I have explained what I am after this time a little clearer than my last two or three efforts.
In the meantime, whilst waiting and praying an answer may come from either you goodself or from one of the many other experts users out there like you - I'll will continue to find the solution myself using your formula and any others I can think up.
Hopefully in this way I will still be learning even if it might be the hard way.