Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-14 Thread Stephan Zietsman
Ian Whitfield wrote: 1) How do I work out what ROW NUMBER a given unique value is on? 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS? 3) How do I get the VALUE in that CELL ADDRESS? [...] 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these values

[libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-11 Thread Ian Whitfield
Hi All Thanks for all the help offered by the Group - It's very much appreciated!! And with this help - although I never got an exact answer - I have been able to solve it!! Basically my question could be broken down into three parts 1) How do I work out what ROW NUMBER a given unique

Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-11 Thread Johnny Rosenberg
2011/12/11 Ian Whitfield whitfi...@telkomsa.net: Hi All Thanks for all the help offered by the Group - It's very much appreciated!! And with this help - although I never got an exact answer - I have been able to solve it!! Basically my question could be broken down into three parts 1)