![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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. |
#3
|
|||
|
|||
![]() Quote:
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 ![]() Thank you |
#4
|
|||
|
|||
![]() Quote:
how can I do this? Thanks |
#5
|
||||
|
||||
![]()
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. |
#6
|
||||
|
||||
![]()
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
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
![]()
Thank you so much
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? | Hoser | Word | 1 | 03-17-2017 03:47 PM |
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open | kdash | Word | 0 | 05-06-2015 09:38 AM |
![]() |
ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
![]() |
bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
![]() |
FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |