Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2017, 10:53 AM
NBVC's Avatar
NBVC NBVC is offline help with excel Windows 7 64bit help with excel Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote
  #2  
Old 06-01-2017, 11:18 AM
adrianoromano adrianoromano is offline help with excel Windows 10 help with excel Office 2013
Novice
help with excel
 
Join Date: Jun 2017
Posts: 5
adrianoromano is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
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
Reply With Quote
  #3  
Old 06-01-2017, 12:38 PM
adrianoromano adrianoromano is offline help with excel Windows 10 help with excel Office 2013
Novice
help with excel
 
Join Date: Jun 2017
Posts: 5
adrianoromano is on a distinguished road
Default

Quote:
Originally Posted by adrianoromano View Post
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
Reply With Quote
Reply



Similar Threads
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
help with excel How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? ADubin Excel Programming 3 02-08-2015 04:57 AM
help with excel [Excel 2007] Building Power Point Slides from data in an Excel Table bremen22 Excel Programming 1 08-07-2013 11:01 AM
help with excel Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft