Search code examples
libreoffice-calc

How to check two different column values

I have the following table

Name Salary Grade
AA    10000  1
A      8000  1
B     11000  2

I want to extract the records where Name starts with 'A' and salary > 10000

I tried to solve first part by the use of regular expression as ^A along with the Name as the criterion to be matched in 'advance filters' under 'Data' tab in libreoffice-calc. However, I am getting blank rows as output.

I need help regarding the testing of such two conditions.

Solution

  • From the comment by @stickybit:

    Use a "Standard Filter" with "Name" "Begins with" "A".