Count last consecutive run of data in a row 1

[Mon Wimp]

hi there.

I am needing help with a function to count the last group of cells used in a range.

eg: on (row1) col (a:b)has data in them and col(c) is blank, and col (d:g) has data, so the answer would be 4. I hope this makes sense

Allan

Ps This may have come through twice as i lost my concection ,Sorry

 

[venkat1926]

in some cell in any other row (other than row 1) type this formula and see

=COUNTA(1:1)

 

[barry houdini]

Assuming your data is within A1:Z1 try

=1/LOOKUP(2,1/FREQUENCY(IF(A1:Z1<>"",COLUMN(A1:Z1)),IF(A1:Z1="",COLUMN(A1:Z1))))/1

confirmed with CTRL+SHIFT+ENTER

 

[Mon Wimp]

Thanks For venkat1926, but barry houdini's formula was the go.

Thanks barry. it worked a charm

Allan

 

[Mon Wimp]

Thanks For the input venkat1926, but barry houdini's formula was the go.

Thanks barry. it worked a charm

Allan