I stopped to find a formula that shows me the values of another sheet at an interval of 100 lines.
n the attached file you will find the example
in the Data sheet in D5 I would like to report the values
found in the SA VEN sheet starting from N80 with 100-row slots.
I know I need to use Indirect but I couldn't set it.
Thanks
use INDEX, do not use INDIRECT.
=INDEX('SA VEN'!N:N,80+100*(ROWS(D$5:D5)-1))
copied down
change , to ; per locale requirements
In D5:
=IFERROR(1/(1/INDEX('SA VEN'!N:N,80+100*(ROWS(D$5:D5)-1))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
You can try OFFSET function.
=OFFSET('SA VEN'!$N$1,(-1)+((ROWS(D$4:D4)-1)*100)+80,,)
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Perfect
Thanks all correct 3 solutions
Thanks to the next one
Last edited by Berna11; 10-21-2019 at 12:26 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Will you please also respond to the private message I have sent to you. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks