How do I find the first value in a range of cells 3

[puforee]

On a 2003 Excell spreadsheet I have a row that consists of many columns. 11 of these columns (11 fields for each row) might contain data. I created a new column, just to the left of the 11 columns, and in its cell (field) I want to return the value of the first cell that has data...out of the 11 cells to the right.

I tried to do a little chart to show this but...when previewed it looked bad.
Can anyone help...Function or VB.

Thanks,

 

[SkipVought]

hi,

Take a look at the INDEX() function.

For instance for row 2 it might be...
[tt]
=INDEX(A2:K2,1,1)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[puforee]

SkipVought...great suggestion...and in doing more research I came up with this.
=INDEX(A1:A10,MATCH(TRUE,A1:A10<>0,0)) 'First entry'
=INDEX(A1:A10,MATCH(TRUE,A1:A10<>0,1)) 'Last entry'

This code returns the value of the first cell that has data or the last cell that has data.

Thanks for your imput. It helped.

 

[SkipVought]

I missed, the "...that has data" qualification. Sorry.

That being stated, I would not have known that solution. Great tip worth at least one [purple]STAR[/purple]!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}