| Author |
 Topic  |
|
|
m_kera
Netherlands
2 Posts |
 Posted - 06/05/2020 : 03:55:50 AM
|
Hi,
I have some problem programming following: I have quite big database with data of 3 variables. It is divided in such a way that 1 variable divides data to different sheets, 2 variable divides to columns and 3 is used as x variable. Now I need to extract very specific points from this database. In 3 columns I have stored the 3 variables for which I need to extract the values. The question is how can I refer to those values and change them into sheet and column names? Can someone have any suggestion? |
|
|
Chris D
428 Posts |
Posted - 06/08/2020 : 11:01:56 AM
|
If you are looking for a text representation of those variables, perhaps making text that looks like a LabTalk range. For example, assuming point 9 in column D in Sheet3 in Book1:
[Book1]Sheet3!D[9]
Maybe something like that?
Perhaps i misunderstand what you want however.
Thanks,
Chris Drozdowski
Originlab Technical Support
|
 |
|
|
m_kera
Netherlands
2 Posts |
Posted - 06/08/2020 : 12:00:28 PM
|
Hi Chris,
Thanks for the reply. I tried to make range notation but it just not working the way I want it. I'm not doing something right. What I need is something like below, where my sheet name, column and row names can be taken from the columns next to it but I'm not even sure if that's possible.
1 5 5 1![5,5]
1 3 8 1![3,8]
1 8 6 1![8,6]
5 7 4 5![7,4]
8 1 3 8![1,3]
9 1 6 9![1,6]
Thanks,
Monika |
|
|
|
kislein
USA
1 Posts |
Posted - 07/05/2020 : 12:47:05 AM
|
| Pretty cool and awesome. |
|
|
| |
Topic |
|
|
|
reference to sheet name and column