Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den sön 30 maj 2021 kl 18:05 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > On 2021/05/29 23:36, Johnny Rosenberg wrote: > > Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < > > hyl...@conacher.co.za>: > > > >> Hi Johnny, > >> > >> On 2021/05/28 23:44, Johnny Rosenberg

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Bravo Remy, On 2021/05/29 20:29, Remy Gauthier wrote: Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

On 2021/05/29 23:36, Johnny Rosenberg wrote: Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi, I have LO

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hello, I created something that ressembles what Johnny created, and I understand your data is formatted like so: Data1 Data2 blank Data3 Data4 blank Data5 Data6 You want Data6 to be the maximum of Data2 and Data4 (and possibly more columns as well), and you want to have Data5 equal to the date on

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > Hi Johnny, > > On 2021/05/28 23:44, Johnny Rosenberg wrote: > > Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < > > hyl...@conacher.co.za>: > > > >> Hi, > >> > >> I have LO 7.0.6.2 and am

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hi Johnny, On 2021/05/28 23:44, Johnny Rosenberg wrote: Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availability

Re: [libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > Hi, > > I have LO 7.0.6.2 and am battling with understanding which formula to > use as well as the syntax for that formula. > > I am aware of the availability of vlookup, hlookup, Index/Match formula > and

[libreoffice-users] Calc Formula confusion an understanding needed Index/Match

Hi, I have LO 7.0.6.2 and am battling with understanding which formula to use as well as the syntax for that formula. I am aware of the availability of vlookup, hlookup, Index/Match formula and have settled I think on the right one i.e. Index/Match Below is a portion of my spreadsheet that