Hi Ian I think a VLookup function might help. But I'm not sure I understood your problem. Can you post a link to an example file?
Cheers, Pedro Ian Whitfield wrote > > Hi All > > I have a spread sheet in LO 3.4.3 where I record and analyse monthly > numbers and amounts for a electricity bill. > The figures for each month are all in one Row. > > Below this I have "Allocation Blocks" that allocate the top figures to > different sub-users. > Like this... > > A B C D > 1 Jan 00 00 00 ........etc > 2 Fed 00 00 00 ........etc > 3 Mar 00 00 00 ........etc > 4 Apr 00 00 00 .........etc > > _ANALYSIS FOR (Month)_ > > Name - Cell n + Cell n (where the 'n' has to be the correct Month Row) > Name - Cell n + Cell n (ie it increments by one for each month) > etc > > I have simplified the above but this is the basic concept. > > How can I modify the formula to pick-up the correct Row for the month I > wish to do the analysis - and printout the report for? Is there a way to > pick-up the 'Month' in the Analysis Block and use this to select the > correct row? > (In Basic this would have been "If 'Month'=Jan then Row=1" etc etc > > Hope you follow me. Thanks for any help. > > Ian Whitfield. > -- View this message in context: http://nabble.documentfoundation.org/Identifying-the-correct-row-in-Spreadsheet-formulas-tp3573062p3573062.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
