On 10/08/2022 19:28, Hylton Conacher (ZR1HPC) wrote:
Great idea. I currently do a similar thing loading the data csv file
direct into MySQL every day with a Perl script and then display my
queries and analysis in web pages for our employees using PHP. For me
this is much simpler and more flexible and than Calc or Base, especially
in a multi-user environment
Hi Steve, et al,
On 2022/08/09 23:05, Steve Edmonds wrote:
Further to Johnny's question, how is the CSV delimited. Do you just
have commas between values or are some values also quoted in " ".
There are no " "'s, all comma separated.
When I import a simple CSV using Sheet>Insert sheet from file I can
set the simple date column as type date at import and using the
MAXIFS solution proposed by Michael [ in my test
=MAXIFS($C$2:$C$18,$B$2:$B$18,">="&G2,$B2:$B$18,"<"&(G2+1)) ] works
well in a test.
Steve, As a courtesy I have sent you a month's worth of data in a csv
file downloaded from my Ambient Weather station cloud account. Try it,
as by no means is it a simple one especially when all you want is the
rainfall on each of the days of the month. into Base
My understanding is that VLOOKUP only returns 1 value, rather than a
vector from which to determine a date.
I believe what I need to accomplish cannot be done with VLOOKUP and
that a combination of INDEX(MATCH()) is a better solution especially
given that the RAW Data file import is going to grow approximately 1MB
per month, despite being just .csv type.
Moving on from this means that the whole file should preferably be
manipulated in Base.
Sorry for wasting everyone's time, Base questions coming soon 0:)
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
(message not available)
Re: [libreoffice-users] [CLOSED] VLOOKUP Syntax to find MAX on a particular date · Hylton Conacher (ZR1HPC)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy