Thanks.
there will always a number less than 1 in a row and I did try the
fomula
"=MATCH(TRUE,SUBTOTAL(9,OFFSET(A1,0,COLUMN(A1: T1)-COLUMN(A1)))<1,0)-1"
and it did worked for a while, but is not stable. Sounds strange?
I tried it this morning, it all provided the right output. But after I
was trying to retype the fomula, it does not work anymore. Then I
re-copied the fomular and it still does not work. Always came out as
"#N/A".
The other fomular did not really work and results in "#N/A".
Two more questions:
1. if I need to count numbers greater than 1.2, shall I change the
fomular into below?
"=MATCH(TRUE,SUBTOTAL(9,OFFSET(A1,0,COLUMN(A1: T1)-COLUMN(A1)))<1.2,0)-1"
2. What do you guys mean by "...confirmed with CONTROL+SHIFT+ENTER"?
Thanks very much.
--
yeedao
------------------------------------------------------------------------
yeedao's Profile:
http://www.excelforum.com/member.php...o&userid=26268
View this thread:
http://www.excelforum.com/showthread...hreadid=395619