INDEX do not work

[Øyvind Granberg]

hi...

I have this cell containing
{=INDEX(poeng_1;MATCH(9.99999999999999E+307;poeng_1))}
It stopped working.

It's supposed to fetch the last numer i a column but not the nulls
It shows 0 even though it should say 24 right now..



--

Kind regards
Øyvind Granberg

(e-mail address removed)
www.tresfjording.com

 

[RagDyeR]

There's nothing wrong with your formula, although it *doesn't* need the CSE
entry (if that's what the curly brackets signify), AND it could be shortened
to:

=INDEX(poeng_1;MATCH(99^99;poeng_1))

OR

=LOOKUP(99^99;poeng_1)

I would suspect something's different with your data.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------



hi...

I have this cell containing
{=INDEX(poeng_1;MATCH(9.99999999999999E+307;poeng_1))}
It stopped working.

It's supposed to fetch the last numer i a column but not the nulls
It shows 0 even though it should say 24 right now..



--

Kind regards
Øyvind Granberg

(e-mail address removed)
www.tresfjording.com

 

[Oyvind Granberg]

Hi RagDyeR
Tested your suggestions.
None of them worked.
Any other formula containing the area poeng_1, which means points_1, shows
the correct number.

I don't know if it has some significance, but I copied this one spreadsheet
from another workbook.
Could that be the cause of my troubles?
But, I have retyped the formula many tmes, but in vain..

It all worked earlier...
I just copied the formulas and the formatting...?!?

 

[RagDyeR]

Are you *sure* that the data in "poeng_1" is truly numeric?
It might be TEXT that just looks like a number.

Choose a cell from that range that contains a number, say it's C9,
and enter this formula anywhere:

=Isnumber(C9)

What result do you get?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Hi RagDyeR
Tested your suggestions.
None of them worked.
Any other formula containing the area poeng_1, which means points_1, shows
the correct number.

I don't know if it has some significance, but I copied this one spreadsheet
from another workbook.
Could that be the cause of my troubles?
But, I have retyped the formula many tmes, but in vain..

It all worked earlier...
I just copied the formulas and the formatting...?!?

 

[Oyvind Granberg]

When I test =ISNUMBER(K10) I get TRUE in return
When I test =ISNUMBER(poeng_1) I get FALSE in return.

I will now check the 52 cells containing av formula in poeng_1
Do I have to do that with the emty cells in the column of K10:K1375?

 

[Oyvind Granberg]

poeng_1 = k10:k1375
Only every 25.th cell contains a formula. (K10, K35, K60, K85, K110 etc)
All empty cells return FALSE when using =ISNUMBER(K10) and copy down.
The cells, K10, K35, K60, K85, K110, K135, K160 and K185 returns the value
TRUE, but from K210 all cells however returns FALSE even though every 25.th
cell should return TRUE.

Why, may I ask?

 

[Oyvind Granberg]

.... of course...
It was trouble with the dates..
The formulas works fine.
I was messing with the wrong dates...
Sorry.. just forget the whole thing...

I am very sorry that my forgetfulness have bothered you all...

 

[Ragdyer]

Glad you finally got it sorted out.

Appreciate the feed-back.