Re: [libreoffice-users] Calk - lookup cell in column

At 08:36 13/09/2013 -0700, Graham Lovatt wrote:
> Calk - lookup cell in column

I imagine it's your spelling checker that thinks Calc is called Calk?

> I have a spreadsheet that records data for each day of the year. 
> Vertically row by row I have the days of the year. I like my week to 
> start on a Monday. So I have my year/days set to start on the first 
> Monday of the year. So the actual first day of the year position/row 
> is dynamic either on the Monday or above.

Er, can you run that last sentence past me again, please?!

> This all works ok

Nice to hear it!

> However I then (for manipulating data by month) need to know the 
> row/cell in which the first day of the year (or month) appears. How 
> do I look up/find within a column the cell in which the first day of 
> the month is - I assume that if I know how to do it for say January 
> then I can do it for any month. I'm totally clueless as to how to do this.

I fear so shall any one else be!  One likely possibility is to use 
VLOOKUP(), which enables you to look for a match in the date 
column(s) and then retrieve data from the corresponding cells in 
neighbouring columns.  But exactly how you do this depends on the 
form of your date data.  Do you have a single column of proper dates 
(however formatted)?  Or by "days of the year" do you mean that you 
have an integer from 1 to 365 or 366?  Or do you have this data 
spread between more than one column - perhaps with the month in one 
column and the day in another?  Or what?

It might help if you list the date data for the first few days of the 
current year.  This might explain both conundrums.

> /Hopping that my explanation isn't to bamboozling/

Gymnastics quite unnecessary, in fact.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@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