Thread
:
R: function - find first number in row 0, return cell column number
View Single Post
#
1
Posted to microsoft.public.excel.programming
r[_4_]
external usenet poster
Posts: 7
R: function - find first number in row 0, return cell column number
maybe I did not understand, try for only numbers:
=MIN(IF(1:10,COLUMN(1:1)))
and with text value:
=MIN(IF((1:10)*ISNUMBER(1:1),COLUMN(1:1)))
regards
r
Reply With Quote
r[_4_]
View Public Profile
Find all posts by r[_4_]
R: function - find first number in row 0, return cell column number