2011/12/9 Pedro <pedl...@gmail.com>: > 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.
I would take a look at MATCH(). You can use Ctrl+F2 to experiment with different functions in a more graphical way. After selecting a function, you can click Help for more information about that function. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
