Ask Your Question

Do these featured exist? list all rows with the "N" column being less than 100

asked 2019-05-07 16:51:08 +0200

squoril gravatar image

updated 2020-08-03 12:40:31 +0200

Alex Kemp gravatar image

Im building a tracking spreadsheet and would like to have an overview page showing whats coming due soon

I have a sheet with a time remaining column holding a decimal number

I would like to have a seperate sheet thats shows all the rows with less than 100 in the time remaining column

What tools "keywords" should i be learing about

LONG VERSION I have 4 sheets, overview, hourly, calendar, and cycles. I want the overview page to show from each sheet the hourly rows with less than 100, calendar rows with less than 12 months, cycle rows with less than 500

I have the sheets set up to where you have one hour, cycle and date input and calculates all the remaining values. What i have no idea how to do, or even if it can be done is extracting the relevant rows and displaying them accordingly

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-05-07 17:07:32 +0200

karolus gravatar image

have a look on

>Data > Filter > Standardfilter …

edit flag offensive delete link more


If you want some excerpts to be copied to overview table, I'd suggest to go for Data -> Tools -> Advanced Filter since this includes a "Copy results to" option / functionality.

Opaque gravatar imageOpaque ( 2019-05-07 18:53:01 +0200 )edit

@Opaque: …as well the Standardfilter does!

karolus gravatar imagekarolus ( 2019-05-07 19:05:32 +0200 )edit

:-) Thanks, never noticed.

Opaque gravatar imageOpaque ( 2019-05-07 19:33:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-07 16:51:08 +0200

Seen: 30 times

Last updated: May 07 '19