Array of "Checked" entries

[ThisIsChad]

I have a table of the following columns:
Have (Boolean), Eligible (Boolean), Item (String)
I want to use this to populate a data validation dropdown with entries from the item column that have a TRUE in the Eligible column. Can anyone show me how? Thanks.

[DGagnon]

could you attach a sample sheet please?

[DGagnon]

here is a sample of what i think you are trying to do, check out the named range, it is refrencing the following:

=INDIRECT("Sheet1!G2:G"&COUNTA(Sheet1!F:F)-COUNTIF(Sheet1!F:F,"BLANK")+1)

you can adjust to fit your sheet.

[ThisIsChad]

That's not working for me, but I failed to mention that I'm using LibreOffice Calc.

[DGagnon]

Sorry i only have experience with MS Office products. you should mention that in the title of your thread.

[ThisIsChad]

Sorry, thanks anyway.