Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find number in a row
Dear All,
Please see the below: Colum A B C D E F item 1 -- -- 10 -- --- item 2 -- 20 -- 20 -- item 3 -- --- -- -- 10 By a formula i wish to extract/find the first availabel number in a row. Please help me..thanking you...john britto |
#2
|
|||
|
|||
Hi
For row 1: =MATCH(TRUE,ISNUMBER(B1:F1),0) entered as array function (Ctrl+Shift+Enter) und copy down for rest of rows. Arvi Laanemets "John Britto" <John wrote in message ... Dear All, Please see the below: Colum A B C D E F item 1 -- -- 10 -- --- item 2 -- 20 -- 20 -- item 3 -- --- -- -- 10 By a formula i wish to extract/find the first availabel number in a row. Please help me..thanking you...john britto |
#3
|
|||
|
|||
He wants the number Arvi
=INDEX(B1:F1,MATCH(TRUE,ISNUMBER(B1:F1),0)) still an array formula -- HTH RP (remove nothere from the email address if mailing direct) "Arvi Laanemets" wrote in message ... Hi For row 1: =MATCH(TRUE,ISNUMBER(B1:F1),0) entered as array function (Ctrl+Shift+Enter) und copy down for rest of rows. Arvi Laanemets "John Britto" <John wrote in message ... Dear All, Please see the below: Colum A B C D E F item 1 -- -- 10 -- --- item 2 -- 20 -- 20 -- item 3 -- --- -- -- 10 By a formula i wish to extract/find the first availabel number in a row. Please help me..thanking you...john britto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
Find number of days between to dates | Excel Worksheet Functions | |||
How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |