Support Board
Date/Time: Fri, 07 Feb 2025 00:34:16 +0000
Post From: Beginner spreadsheet help with range in column?!
| [2020-05-12 20:11:50] |
| User130862 - Posts: 20 |
|
Hello, First sorry for wasting valuable space here on support forum for questions likes this. I have just found out about spreadsheets and if I liked Sierra before I like it even more now. Read the documentation and followed it but receive #VALUE! error when trying to get the first 5 items in a specific column. Everything I have tried gives me #VALUE! error. Why I really don´t know. Tried this: =ID1.SG4@3:ID1.SG4@7 And this: =OFFSET(ID1.SG4@3, 0, 0, 5, 1)
And this: =AD3:AD7
But I always get #VALUE! "error". What am I doing wrong? |