Validity lists in LibreOffice Calc. Conditional validity lists
This is a tutorial on LibreOffice calc covering, validity lists, conditional validity lists, the indirect function and named ranges. The tutor demonstrates how to create a validity list using named ranges and lists. The tutor explains how to create a conditional validity list using named ranges and the Indirect function. The tutor goes on to recreate an example. Stepping through each phase. The process work by using named ranges, whatever name range the Indirect function displays is the list that will be available in the validity list. This is a calc tutorial. Validation lists in LibreOffice Calc. LibreOffice Calc tutorial.
#calc
#libreofficecalc
#libreoffice
If you want to support me, check this out: / itseasy
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-sa...
Training Guide Books:
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv