Support Board
Date/Time: Wed, 24 Dec 2025 18:25:59 +0000
Post From: Beginner spreadsheet help with range in column?!
| [2020-05-13 11:06:00] |
| User130862 - Posts: 20 |
|
Greetings, I only want x amount of first cells in a column without any built in function. Reason is, since I have 5 different charts in chartbook with spreadsheet study. I get 5 sheets which is wonderful. However I will create a new blank sheet and then use reference to the other 5 with sheetname! but I want only top 5 cells of a specific column. Possible? #### EDIT #### Think I have found a work around by copy first formula and then paste it underneath the first one and then do this 5 times. =Sheet1!ID0.SG1@3 Did not realize the row ID changes automatically when pasting, great indeed! Once again I must praise the programmers who are involved in this magical software. You surprise me each day of how well designed and how powerful it really is. Date Time Of Last Edit: 2020-05-13 19:09:09
|