LibreOffice Calc 7.6.3.2
Windows 11
I have a simple LibreOffice Calc file with 2 sheets:
- A sheet called Randomizer which returns a new random row from the Problems sheet based on some values.
- A sheet called Problems which basically contains the data of the document.
In the Randomizer sheet, I was able to return a random problem from within the Problems sheets.
However, I want to also be able to return a random problem based on certain column values.
How can I achieve that?
I would love to have everything done via only formulas.
Like I just did with the general randomizer.
I do not mind if the resulting formula is either slow or inefficient, as long as it works.
The list of problems is only going to have almost 500 rows of data.
Please, take a look at the workbook that I uploaded.
Thank you.
Problems.ods (24.5 KB)