Questions tagged [google-sheets-filter]

Use this tag for questions about using the filter feature of the user interface of Google Sheets.

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
98 views

Google Sheets: filtering and matching a list treating NON-unique values

I have a list (column A) of non-unique text values. Items from that list are put into column B (via dropdown data validation). Any items from column A that are missing in column B are shown in column ...
1
vote
0answers
14 views

Data has both text and number, I need to move to another sheet from master but only the numbers show up…I need both

I've used this formula =query('Form Responses'!1:136,"Select * Where E='name'") but all I get is the numerical value entered in a cell. If someone enters both a number and text the cell is blank. In ...
1
vote
0answers
14 views

Transform table: Get N top results for each row and replace with header value

I' having a table with names and countries as columns/rows: Goal: Sort each individual row by the N highest (or lowest) values and afterwards replace replace the values with the corresponding header ...
0
votes
0answers
186 views

Can I exclude the bottom row from a Filter in Google Sheets?

I have a spreadsheet in Google Sheets, there is a header and 13 rows containing data. There is then a row containing the average of the cells above. I'd like to be able to sort the various columns in ...
0
votes
1answer
15 views

Filter rows which contain any value on a range of cells in a certain columns

I have a Sheet that contains a list of machines with their serial numbers, owner, date of begin of operation, status and many other parameters. I want to filter only the rows that contain the serial ...
0
votes
0answers
108 views

Why do Google Sheets filter ranges sometimes auto-expand to include new data, and sometimes don't?

When I create a filter in Google sheets, I want the range to automatically expand as I add/populate new rows. Sometimes, this works fine: When I have a column using “Checkbox” data validation (...
0
votes
0answers
28 views

Same value to return multiple match in Google Sheets

I don't know if the title reflect the situation but here it is. I have this kind of information (image below) where: Column A : 1 serial for 100 cells Column B : 10 serials for 100 cells Column C : ...
0
votes
2answers
118 views

How do I count the amount of non-blank cells in a row, including only cells that are in a column that contains a specific value?

Here is my example sheet: https://docs.google.com/spreadsheets/d/1xxmTnRTaA0DPAyibbiXK00YPqhwT5NXH8kf8PtBh0jg/edit?usp=sharing I am trying to create a formula for the column "Total" that would ...
0
votes
2answers
35 views

Filtering on gathered statistics adds dummy empty rows and fails anyway

I have a simple data set: Pupil A Teacher A pass Pupil B Teacher A fail Pupil B Teacher B pass And want to compute the following statistics: Teacher pass rate Teacher A 50% Teacher B ...
0
votes
1answer
90 views

I want to bring in already filtered data into a new spreadsheet

Is it possible to reference filtered data from one sheet to another in Google Sheets? I use the filter button to sort in a master sheet. I then use this formula in a new sheet: =IMPORTRANGE("...
0
votes
1answer
29 views

How can I create a filter on Google sheets to filter only words that begin with uppercase?

I have a column with 2 kind of words: words without uppercase (betrachtet) and words that begin with uppercase (Analysieren) I need a filter that shows my only those words which begin with uppercase....
0
votes
2answers
3k views

Make a filter but exclude one column

I would like to make a filter on Google Sheet but exclude one column For example: In this case I would like to have the filter on Column A and B but the data on Column B should stay as they are, so ...