@normanbg wrote: Yes, I did want to reference the variable by its order in the data vector. Your solution (VAR1 VAR2 ... VAR20) is more or less what the workaround (mentioned in an earlier reply) did, but I was looking for what I thought would be a more elegant solution (one-line, without having to recast the Excel file). I guess there just isn't one. Thank you for your reply.
You still haven't provided an actual use case. You should find that most actual calculations you need to do not involve needing to know either the order of the observations or of the variables.
Excel is a tool for working with SPREADSHEETs. In a spreadsheet you can easily reference any cell or even put any type of data into any cell. Structures that might work well for displaying information to users in spreadsheets are probably not going to work very well for doing data analysis.
... View more
