Assistance with sorting 'csv' sheet

[gil_happy]

Hello,

I need some assistance using LibreOffice Calc along with a .csv file. Using the .csv file stored on my Google Drive (I can’t upload .csv to this forum), I would like to ‘filter’ this sheet on certain values.

Zip_PriceToRentRatio_AllHomes.csv

Here is what I would like to filter:

• display values / results only from the state of ‘AZ’.
• Then looking at column ‘CR’ (2018-02), return only ‘AZ’ values that are less than 13.00.

I would like the end result of the sheet to just display these values. Does anyone know how to do this?

Any help is greatly appreciated.

Thanks in advance!

[mikekaganski]

Look at Data → More Filters → Standard Filter...

[gil_happy]

Thanks, that works! I figured there was something more difficult, or special I needed to do for a csv file.