Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Assistance with sorting 'csv' sheet

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.

https://drive.google.com/open?id=1oy0H5qPYgpMh19aL6d0zXUzBzxcXyBAm

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!