In OpenOffice-Calc, using the advanced filter, how can I compare one column to another?
As an example, I need to filter for items that have less than a 30 days supply. Using the column name
Test, my criteria are below.
I have column headers of
BOH (Bottles on Hand),
Thirty (how many bottles are sold in 30 days) and a new column
Test. I get the following error.
Range does not contain valid query.
Why is the formula returning this error message?