Ask Your Question
0

Assistance with sorting 'csv' sheet

asked 2018-04-16 18:11:16 +0100

gil_happy gravatar image

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=1oy0...

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-04-16 18:22:43 +0100

Mike Kaganski gravatar image

Look at Data->More Filters->Standard Filter...

edit flag offensive delete link more

Comments

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

gil_happy gravatar imagegil_happy ( 2018-04-16 19:18:34 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-16 18:11:16 +0100

Seen: 24 times

Last updated: Apr 16