help with excel

[adrianoromano]

Hi guys and sorry for my bad english.



I try to explain in a simple way my problem. For example: I want cell C1 to be equal to cell A100 (for example), but I don't want to write "=A100" in cell C1 because I want to obtain 100 as function (to give a simple example 50+50).

The problem is that I can't write in cell C1 "=A(somma((50+50))" because Excel will return an error.
How can I do thi apparently simple task?

Thanks

[NBVC]

maybe..

=INDEX(A:A,50+50)

You will need to translate to your language...

this will pull the value from A100 into cell C1. You can change the 50+50 as needed.

[adrianoromano]

Originally Posted by NBVC

maybe..

=INDEX(A:A,50+50)

You will need to translate to your language...

this will pull the value from A100 into cell C1. You can change the 50+50 as needed.

Ok thank you,

another question: I have a number in C10 and another numberin C16. In cell H10 I want to obtain the value of C16 and I tried to write this: "=indice(D,=rif.riga(d10)+6)" but it doesn't work. why?

Thank you

[adrianoromano]

Originally Posted by adrianoromano

Ok thank you,

another question: I have a number in C10 and another numberin C16. In cell H10 I want to obtain the value of C16 and I tried to write this: "=indice(D,=rif.riga(d10)+6)" but it doesn't work. why?

Thank you

Hi, rephrase my problem in another way. I need a function that given some numbers in column A returns only some of them. In others words I want to obtain in cells B1,B2,B3 etc the values of A10, A20, A30 etc respectively. That is, there is a distance of 10 between rows in column A.
how can I do this?

Thanks

[NBVC]

Try:

=INDEX(A:A,10*(ROWS($A$1:A1)-1)+10)

copied down.

You may need to adjust if you are not starting at A1.

[Pecoflyer]

Please do not ask multiple questions i the same thread.
Create a new thread for each question and eventually add a link to existing thread(s) if necessary.
Thank you

[adrianoromano]

Originally Posted by NBVC

Try:

=INDEX(A:A,10*(ROWS($A$1:A1)-1)+10)

copied down.

You may need to adjust if you are not starting at A1.

Thank you so much