google-sheetsfiltergoogle-sheets-formulafilteringflatten
Filtering a Non-Unique Data Set in Google Sheets
I have a list of recipe, and I also have a list of sold menu. Is there any way that can filter the recipe (can be with query, or not) by looking at the menu (that can repeat more than once)?
https://docs.google.com/spreadsheets/d/1Ire32u7kELCAu07AHiTGt8yoXwCWDpvT77nQYSN21DU/edit#gid=0
This is the sample case
- A2:B7 is the list of recipe
- D2:D7 is the list of menu sold
- F2:F13 is the desired result
Arrayformula is preferred since I don't have to drag down again when the data set get bigger.
Solution
try:
=FLATTEN(BYROW(D2:D7, LAMBDA(x, TRANSPOSE(FILTER(A2:A7, B2:B7=x)))))
- Google Sheets Script - passing a range as a function parameter
- Google Sheets formula to move and clean an array of data
- Searching for text in a column in google sheets, and determining if text exists in that range
- How to calculate running average with 1 formula in Google Sheets?
- Adding a row to a filtered range
- How to format a cell value in Google Sheets with TEXT() and have conditional formatting work as well
- How to Select Specific Ranges in Results
- Generate unique random numbers in Google Sheets
- "Array arguments to COUNTIFS are of different size" - counting the number of rows in Sheets with multiple criteria
- Can an image be inserted inside a Donut Chart in Google Sheets?
- How to get data by filtering YEAR using google sheet script
- Ranking formula in Google Spreadsheet
- Google sheets conditional formatting of lowest n
- Google Sheets Getting data from cells in 1 column using multiple instances of text entry's from a different column
- drive.permissions.create error - too many parameters
- Google Sheets IMPORTXML - Scrape Exhibitor List
- How do I fix this script in Google Apps Script to create a button regarding Date Range?
- How to Add Headers or Categories When Selecting Specific Ranges in Results
- Google Sheets Transpose Formula
- Separate Data in One Column into Multiple Colums
- Get first non-empty cell in row
- How to conditionally change a date based on a time? Time zone differences?
- How to know Sheet ID that using BigQuery Sheet Connector
- Getting the data from the new Google-sheet tab with INDIRECT
- Google Sheets. How to create formula to get 10 highest values from one table and put to another one?
- Use Lambda to stack multiple query array
- Using EOMONTH in Google Sheets considering time not just date
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- Conditional formatting if cell past date and another cell empty with arrayformula
- ranking formula start from negative number