All Questions
Tagged with filter google-sheets
914
questions
1
vote
1
answer
21
views
Display averages of a column for past five months in Google Sheets
I am working with a dataset that has multiple entries per month with different values. For instance, a row of data will have a certain month + year, as well as a value. I'd like to find the average ...
1
vote
1
answer
15
views
Return Top value plus ties for each change in another Column value
Using Columns A to J, I am looking to return the answer in Columns L to N.
I am trying to get the maximum value (plus ties) of Column B for each Tier (Column A) and show the corresponding fixture (...
-1
votes
0
answers
34
views
GoogleSheets ordering matrix columns of 3
I have a dataset organized into 3 columns, being the first row the title.
Data is organized by category DC,PH,DA,PF and date. But imputed in a randomly order
Notice there are 147 columns and 127 rows, ...
0
votes
1
answer
39
views
Google sheet Filter + Match?
I have 2 different reports which I am trying to match the invoice no. in sheet 2 to sheet 1 in google sheet. It is impossible to clean the transaction description column.
I had try to combine Match ...
0
votes
1
answer
15
views
Vlookup + Filter + Sort + Arrayformula workaround in google sheets
I have two tables, RECORDS and TYPES.
Link to a similar spreadsheet
RECORDS has 3 columns, "Type" in column A, "Entry Date" in column B, and "Status on Entry Date" in ...
0
votes
1
answer
29
views
Add a value to filter result in Google Sheets
I have the following formula that works in Google Sheets
=Sort({IFERROR((FILTER({'My Log'!B13:B, 'My Log'!F13:F, 'My Log'!E13:E, 'My Log'!H13:H, 'My Log'!I13:I,'My Log'!J13:J, 'My Log'!K13:K,'My ...
0
votes
1
answer
25
views
Data Validation google sheets partial match
I have a tab in Google sheets with vehicle data coming from a google form. I made another tab to filter these data using a data validation. The validations are Car 1, Car 2, Car 3, Truck 1, Truck 2, ...
0
votes
1
answer
44
views
How do I return multiple values using the MATCH function?
I am currently building a cash flow tool to visualize and forecast cash flow within a calendar view.
I built out the calendar so that the headers are the dates and the days show the up to date cash ...
0
votes
1
answer
47
views
RegExtract a value from a comma-separated string
I have a Google Sheet located here: https://docs.google.com/spreadsheets/d/1s7tzyz9A9caaJGbiWPm1CDNBxmnv0Xrh3lb5yj9CDOk/
The first tab simply collects information from a Google Form. Enter your name (...
0
votes
1
answer
42
views
Regular expression for Unique Sort finding phone extensions from a multicolumn list
Working within a Google Sheet, I have a list of people's work locations or departments in Columns A or G, their names in Columns B or H, and their extensions in Columns C or I. It is formatted this ...
0
votes
1
answer
30
views
Creating QUERY Drop Down List to Filter Data in Google Sheets with an Image
I am attempting to build a question bank in Google Sheets that have certain characteristics attached to the question (type of question, topic covered, level of difficulty). I want to create a sheet ...
0
votes
1
answer
33
views
Is it possible to use a checkbox to filter results in Google Sheets?
I have a sheet that looks like this:
I would like a formula that filters based on the checkbox in D1. Ideally: if D1=FALSE, do nothing, otherwise filter. Is it possible to do this? I have written the ...
1
vote
2
answers
36
views
Filter with multiple rows and columns in Google Sheet
I am working on attendance in a google sheet where I maintain hourly attendance. I record attendance for 5 hours everyday. In column B9:B40 I have a list of names. In Row F3:3 I have the dates. From ...
1
vote
1
answer
26
views
Google Sheets Formula Filter Combined Values - Separated by Comma's
I am currently working on creating a formula in Google Sheets that can filter both individual values and multiple values combined with commas.
I am facing challenges in understanding how to achieve ...
0
votes
0
answers
28
views
"not equal" condition causing the filter to generate an "N/A" error
I have the following formula in one of my Google Sheets which has worked for years.
=iferror(filter('Flag Duplicates 1'!A2:N,
not(isblank('Flag Duplicates 1'!A2:A)),
'Flag ...