Problem with INDEX formula..

[Guest]

Hi al
First I have to say that this site has helped me heaps lately and I especially thank Frank for all his help.... and I'm stuck again..

In cell X15 I need a formula that will find the first active cell on the row (ie row 15) and report the corresponding date from row 10. I was given the formula below but it reports everything but the correct date (ie it reports 4/4)?? What am I doing wrong? Any help would be appreciated

=INDEX(O10:W10,COUNT(O15:W15)

O P Q R S T U V W X

10 4/4 11/4 18/4 25/4 2/5 9/5 16/5 23/5 30/
11
12
13
14
15 1 1
16

 

[Peo Sjoblom]

Try

=INDEX(O10:W10,,MATCH(TRUE,O15:W15<>"",0))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

Hi all
First I have to say that this site has helped me heaps lately and I

especially thank Frank for all his help.... and I'm stuck again...

In cell X15 I need a formula that will find the first active cell on the

row (ie row 15) and report the corresponding date from row 10. I was given
the formula below but it reports everything but the correct date (ie it
reports 4/4)?? What am I doing wrong? Any help would be appreciated:

=INDEX(O10:W10,COUNT(O15:W15))

O P Q R S

T U V W X

 

[Guest]

Thank Pe
That works great until I hit a row that is blank - it then results in #N/A, can I add anything to the formula to change that to ""

Also, can I add anything to that formula? I may need to add an IF formula at the front that says" If(OR(A15="Late",A15="Past","",........ then I would have the index formula. I tried to add this and it went haywire
Really appreciate your help


----- Peo Sjoblom wrote: ----

Tr

=INDEX(O10:W10,,MATCH(TRUE,O15:W15<>"",0)

entered with ctrl + shift & ente

--

Regards

Peo Sjoblo

Hi al
First I have to say that this site has helped me heaps lately and

especially thank Frank for all his help.... and I'm stuck again..row (ie row 15) and report the corresponding date from row 10. I was give
the formula below but it reports everything but the correct date (ie i
reports 4/4)?? What am I doing wrong? Any help would be appreciatedT U V W

 

[Guest]

Scrub that - I worked it out


Thanks very much