Robert,
Thank you so much! That is exactly what I was looking for!
Just as an addendum for those who are brand new to Libre Office:
If the More Fields Option doesn’t respond (mine didn’t at first and that’s why
I couldn’t find Mail Merge Fields) choose Insert—Field—Command F2
Then once you
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
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
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
Thanks. Good solution.
On 2021-05-28 20:38, Michael D. Setzer II wrote:
Try this:
Highlight full range of Area
In my test A1:F419
For Condition 1
Set to Formula is:
Formula to weekday($a1)=1
Weekday returns 1 for Sunday on my setup (1 to 7)
Just select ERROR as Style (for testing)
With the $a1
Thanks. I misread the help document on Weekday, and didn't read the
ADDRESS help. I initially was using INDIRECT but it wasn't working for
the reasons you mentioned.
On 2021-05-28 20:29, Brian Barker wrote:
At 18:01 28/05/2021 -0400, Gary Dale wrote:
It's been years since I tried to do