About 1,995,075 results (5,560 milliseconds)
Sort & filter your data - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop Custom formula examples. Find unique values within a data range ... On a computer, you can filter data so the filtered data only applies to your view of the ...
"You can't create a filter over a range containing vertical merges ...
https://support.google.com/docs/thread/4927858/you-can-t-create-a-filter-over-a-range-containing-vertical-merges-msg-in-google-sheets-no-merge?hl=en Apr 26, 2019 ... to find easier, try to create a filter column by column and Google will tell you on what row this vertical merge is present. Google user. Aug ...
Sort & filter your data - Android - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DAndroid Filter by values · On your Android phone or tablet, open a spreadsheet in the Google Sheets app. · Tap More · Look at the column titles to see if filters have been ...
Advanced filter function in Excel - Google Docs Editors Community
https://support.google.com/docs/thread/9779002/advanced-filter-function-in-excel?hl=en Jul 12, 2019 ... ... Microsoft Excel, but can't seem to find it in Google Sheets. ... The Filter View uses the flag in column F to determine which rows to show.
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. ... Filter View button/icon and select a created view. - ...
Sort & filter your data - iPhone & iPad - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DiOS Type in the search bar to find a value or scroll up on the list to see the values in the column. Tap an item to uncheck it and filter it out. The sheet will ...
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 ... ... columns, then reseting the filters using the button you made. You ... I migrated quite a complex Excel worksheet solely for the filter view ...
Selecting cell range while having a filter on? - Google Docs Editors ...
https://support.google.com/docs/thread/95171533/selecting-cell-range-while-having-a-filter-on?hl=en Jan 27, 2021 ... In Excel, it's a no-brainer... Details. Sheets,Microsoft ... This should not be the filter's behavior, as one can see from this .gif:.
FILTER function - Google Docs Editors Help
https://support.google.com/docs/answer/3093197?hl=en ... column in range should pass through FILTER . Can also contain array formula ... See Also. UNIQUE : Returns unique rows in the provided source range ...
How to filter data that has cells with hyperlink - Google Docs Editors ...
https://support.google.com/docs/thread/50979813/how-to-filter-data-that-has-cells-with-hyperlink?hl=en Jun 3, 2020 ... I wanted to filter the sheet using column "Notes" so that the records shown are only the ones that have a hyperlink in the said column, see ...
why when I sum a filtered range the sum consider all data not only ...
https://support.google.com/docs/thread/3875129/why-when-i-sum-a-filtered-range-the-sum-consider-all-data-not-only-the-range-filtered?hl=en Apr 9, 2019 ... To get the sum of only visible rows in column A: =SUBTOTAL(9,A1:A) ... Select "Get shareable link"; Change "Anyone with the link can view ...
Find and Replace not working in sorted or filtered filter view - Google ...
https://support.google.com/docs/thread/160363324/find-and-replace-not-working-in-sorted-or-filtered-filter-view?hl=en Apr 18, 2022 ... Now try to do an advanced search in column 2 for the commas. It brings you to the cells that have commas when the data are not sorted, ...
How to Detect Cells that Failed Data Validation - Google Docs ...
https://support.google.com/docs/thread/174285217/how-to-detect-cells-that-failed-data-validation?hl=en Aug 8, 2022 ... ... column to filter data by row. The two references you shared allow you to do essentially the same thing with conditional formatting. You can ...
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 ... When I do it, ALL of the columns change as well. How do I filter just one? I know it's a simple setting but I can't find it. Any help?
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 ... To use the filter formula, enter a search key such as a word or a partial word in row 1. To not search by a particular column, leave that row 1 ...
Filter Views in View Mode - Google Docs Editors Community
https://support.google.com/docs/thread/119592393/filter-views-in-view-mode?hl=en Aug 1, 2021 ... ... activate a filter view. Such filter views can include sorting by a pre-selected column. Cheers --Hyde. Joe 2656. Original Poster. Aug 2, 2021.
Rows have disappeared (not hidden) from sheet - - Google Docs ...
https://support.google.com/docs/thread/200270506/rows-have-disappeared-not-hidden-from-sheet?hl=en Feb 3, 2023 ... You might need to click on each of the little arrows in the data filter row to see which settings are hiding rows. Columns where a filter has ...
Combining UNIQUE and FILTER, how can I exclude a range of data ...
https://support.google.com/docs/thread/13602268/combining-unique-and-filter-how-can-i-exclude-a-range-of-data-instead-of-a-single-data-point?hl=en Sep 4, 2019 ... I have column that auto-generates new entries from Google Forms, and another column where I manually input names I don't want to include in ...
How to create dynamic filter range to hide columns that are entirely ...
https://support.google.com/docs/thread/43569771/how-to-create-dynamic-filter-range-to-hide-columns-that-are-entirely-without-data?hl=en May 1, 2020 ... The solution I am trying to find: I would like to create a dynamic filtered range that would hide a column if none of my respondents play that ...
Filter view to show only rows with nothing in column A - Google ...
https://support.google.com/docs/thread/29701020/filter-view-to-show-only-rows-with-nothing-in-column-a?hl=en Feb 24, 2020 ... I want to create to create a filtered view that contains only the rows where column B is blank. It seems like it should be simple, ...