R: function - find first number in row 0, return cell column number

Posted to microsoft.public.excel.programming

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
function - find first number in row 0, return cell column number	cate	Excel Programming	3	April 19th 11 09:44 PM
Find a number in a column then return a value from another cel	Mark Dullingham	Excel Worksheet Functions	0	May 17th 10 09:57 AM
Function that will look at letter in a column and return a number	locasciok1	Excel Worksheet Functions	4	November 11th 09 06:31 AM
find lowest number and return it's adjacent cell	Erik	Excel Worksheet Functions	7	October 2nd 07 02:37 PM
return the column reference number of a function result	Mahendhra	Excel Discussion (Misc queries)	2	May 16th 05 12:46 PM

All times are GMT +1. The time now is 03:37 AM.

Menu

About Us