Hi Hylton
On 10/08/2022 19:28, Hylton Conacher (ZR1HPC) wrote:
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
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
On 10/08/2022 02:55, Johnny Rosenberg wrote:
Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
On 2022/08/09 14:53, Johnny Rosenberg wrote:
Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
mailto:hyl...@conacher.co.za>>:
Hi Johnny,
Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> On 2022/08/09 14:53, Johnny Rosenberg wrote:
> >
> >
> > Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
> > mailto:hyl...@conacher.co.za>>:
> >
> > Hi Johnny,
> >
> > On 2022/08/08 22:19,
On 2022/08/09 14:53, Johnny Rosenberg wrote:
Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
mailto:hyl...@conacher.co.za>>:
Hi Johnny,
On 2022/08/08 22:19, Johnny Rosenberg wrote:
> Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC)
>
On 2022/08/08 23:55, Michael H wrote:
1. Vlookup can only return columns to the left of the column you search
so you need to introduce the date into a leftward column (N2=B2, copy
it, paste into column N, all rows)
All the examples I see on the net show that the left most column is the
one
Hi Johnny,
On 2022/08/08 22:19, Johnny Rosenberg wrote:
Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC)
mailto:hyl...@conacher.co.za>>:
Hi,
Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in
excess of 65k rows. A three column sample below:
Date
For the following I assumed the “simple date” column is is date format..
If not you can get to that by entering the formula
=IFERROR(DATEVALUE(LEFT($RAW.A3;10));"") and pull that down.
On another sheet I entered the “query date” in B2
The next formula gives you the max temp on that date:
On 8 Aug 2022 at 21:25, Hylton Conacher (ZR1HPC)
wrote:
Date sent: Mon, 8 Aug 2022 21:25:44 +0200
To: LibreOffice Users
From: "Hylton Conacher (ZR1HPC)"
Subject: [libreoffice-users] VLOOKUP Syntax to find
MAX on a
Hi,
Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in
excess of 65k rows. A three column sample below:
DateSimple Date Outdoor Temp
2022-01-01T00:05:00+02:00 2022-01-01 00:05:00 17.5
2022-01-01T00:00:00+02:00 2022-01-01
10 matches
Mail list logo
