Hi All
Can someone help me with some syntax please??
I have a two-sheet Calc Spreadsheet. All my data lives on the first
sheet called Data and my Analysis Reports are on Sheet Two.
I have the same values in any given Column in my Data Sheet, (ie all my
Totals are in Column D), and - as per
Hi,
Message du 14/12/11 14:29
De : Ian Witty Whitfield
A : users@global.libreoffice.org
Copie à :
Objet : [libreoffice-users] Syntax Question
Hi All
Can someone help me with some syntax please??
I have a two-sheet Calc Spreadsheet. All my data lives on the first
sheet called
On 14/12/2011 16:04, Gérard FARGEOT wrote:
=INDIRECT(Data.Data.H5Data.M9)
with Letters column identifier in Data.H5 and number row identifier in Data.M9
If column identifier is a number, you can use INDIRECT ADDRESS
=INDIRECT(ADDRESS(Data.M9;Data.H5;4;;Data))
Thanks Gerard
PERFECT -