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

The closest I came to a solution was a scenario where all the dates for 
the year were in one column.

I put the dates for the year (Monday 12/31/2012 thru Sunday 1/5/2014 in  
A5:A375.
Then, in A1 I put whatever date I'm looking for.
Off to the side (D1) I entered: =VLOOKUP($A$1,$A$5:$A$375,1,0)-(A5-1)+4
     VLOOKUP(A1,$A$5:$A$375,1,1) finds the date you're looking for.
     -(A5-1) subtracts the day before the first date on the list FROM 
the date found.
     +4 adds in the four rows above the range.
The result is the row number of the date you're looking for.

I hope this helps.

-- Tim
===========================


On 9/13/2013 11:36 AM, IGraham wrote:
> Hi
>
> Now this might take a bit of explaining
>
> 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
> This all works ok
>
> 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
>
> /Hopping that my explanation isn't to bamboozling/
>   
> Any ideas - please
>
>
>
> -----
> IGraham
>
> W764  LibreOffice 4.1.0.4
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calk-lookup-cell-in-column-tp4074117.html
> Sent from the Users mailing list archive at Nabble.com.


--
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