About 1,172,376 results (5,527 milliseconds)
How to lock a row to move with a filter on a column - Google Docs ...
https://support.google.com/docs/thread/139208234/how-to-lock-a-row-to-move-with-a-filter-on-a-column?hl=en Dec 7, 2021 ... I am a recent transfer from excel and I am having trouble ... If you only select one column and apply Filter > Sort, Sheets has no ...
Sort & filter your data - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop If your columns have titles, click Data has header row. Select the column you'd like to be sorted first and choose a sorting order. To add another sorting rule, ...
Sheets Filter not working correctly - Google Docs Editors Community
https://support.google.com/docs/thread/13200579/sheets-filter-not-working-correctly?hl=en Aug 31, 2019 ... We have a spreadsheet with some filters and conditional formatting in different columns. ... then apply a new filter to the correct range of cells.
I want to create a macro to apply a filter (created in Data tab) then ...
https://support.google.com/docs/thread/42520476/i-want-to-create-a-macro-to-apply-a-filter-created-in-data-tab-then-copy-and-paste-into-another?hl=en Apr 25, 2020 ... ... apply a filter (created in Data tab) then copy and paste into another. I have created a filter that filters 2 columns in my data set of 15 ...
How to filter multiple columns that share the same merged header ...
https://support.google.com/docs/thread/93234649/how-to-filter-multiple-columns-that-share-the-same-merged-header-as-one-filter?hl=en Jan 12, 2021 ... One filter, for all the columns under the merged headers. Now, if I want to find mangoes, I don't have to filter every column.
Using a filter function to filter data in another sheet, but adding new ...
https://support.google.com/docs/thread/87125050/using-a-filter-function-to-filter-data-in-another-sheet-but-adding-new-column-data-to-the-new-sheet?hl=en Dec 6, 2020 ... You may want to use a drop-down list to record the Stage instead of using several checkbox columns. You can then use filter views to limit the ...
Google Sheets: Column filter not working - Google Docs Editors ...
https://support.google.com/docs/thread/3082766/google-sheets-column-filter-not-working?hl=en Mar 26, 2019 ... In the linked Sheet (I just created random data), I am unable to get a column filter to apply. I can't get this to work in any Sheet I ...
I simply want two of my columns to have filters - Google Docs Editors ...
https://support.google.com/docs/thread/99581796/i-simply-want-two-of-my-columns-to-have-filters?hl=en Feb 24, 2021 ... The formula is in cell A3 . To use the filter formula, enter a search key such as a word or a partial word in row 1. To not search by ...
How to use multiple filters at the same time? - Google Docs Editors ...
https://support.google.com/docs/thread/160139208/how-to-use-multiple-filters-at-the-same-time?hl=en Apr 16, 2022 ... I have a sheet where I have four columns. I want to set it up so that there are two pairs of columns that sort independently of one another ...
How to set custom view filter columns in Google Sheets? - Google ...
https://support.google.com/docs/thread/2266784/how-to-set-custom-view-filter-columns-in-google-sheets?hl=en Mar 12, 2019 ... I've made good use of the Filter Views, but these only hide info within the column - not the whole columns themselves. What solution would ...
Sort & filter your data - Android - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DAndroid You can sort columns of cells alphabetically and numerically. On your Android phone or tablet, open a spreadsheet in the Google Sheets app. To select a column, ...
Filter only one column in Sheets?? - Google Docs Editors Community
https://support.google.com/docs/thread/44752561/filter-only-one-column-in-sheets?hl=en May 5, 2020 ... There's only so much that a screenshot shows. I don't use the auto filter so I can't speak to how it works, but normally filters assume that you ...
Why is my queried data disappearing when I order by a column ...
https://support.google.com/docs/thread/158888242/why-is-my-queried-data-disappearing-when-i-order-by-a-column?hl=en Apr 6, 2022 ... A1:BZ } in cell A1 , hide the columns you do not need on that Invoicing sheet, append any additional columns to the right, and then use a filter ...
I need to extract data from multiple columns based on the date ...
https://support.google.com/docs/thread/27901873/i-need-to-extract-data-from-multiple-columns-based-on-the-date?hl=en Feb 6, 2020 ... The FILTER formula is easier to use with dates and since you are looking for monthly results, incorporating the MONTH formula makes this easier ...
Filter function skipping a column - Google Docs Editors Community
https://support.google.com/docs/thread/46905086/filter-function-skipping-a-column?hl=en May 15, 2020 ... If I change it to say B4:H, it will still skip column E, but put column F in it's place and column G in the next column which was supposed to be ...
Including columns in the OpenXML filter for Excel
https://groups.google.com/g/okapi-users/c/Oa6tNNPXkCk Feb 23, 2021 ... I guess as a quick workaround, save your sheets to CSV and use the table filter which allows you to define columns to process, etc. Best ...
Filter multiple columns at the same time - Google Docs Editors ...
https://support.google.com/docs/thread/92287782/filter-multiple-columns-at-the-same-time?hl=en Jan 6, 2021 ... One advantage of the formula is that the display will update dynamically if you add new data or modify your keyword list. The Filter View must ...
Access to filters for users with view-only rights - Google Docs Editors ...
https://support.google.com/docs/thread/259414390/access-to-filters-for-users-with-view-only-rights?hl=en Feb 18, 2024 ... However, for their convienience I would like these other users to be able to use the filters on the differnt columns, so they can find the ...
Shared users cannot use filters where needed - Google Docs ...
https://support.google.com/docs/thread/209650817/shared-users-cannot-use-filters-where-needed?hl=en Apr 5, 2023 ... I want to be able to protect the sheet apart from the first 3 columns, so shared users can't overwrite the formulas pulling data through, but then create ...
In google sheet, how to clear all filters rules in 1 click without ...
https://support.google.com/docs/thread/19196689/in-google-sheet-how-to-clear-all-filters-rules-in-1-click-without-deleting-the-filters?hl=en Nov 10, 2019 ... ... Excel 2010 with 1 button click (located next to the filter icon). I have a data base with 100+ columns, so if I apply many filters, then ...