google-sheetsfiltergoogle-sheets-formulauniquespreadsheet
How to use Query function to list products in stock?
In my query function (cell H3), I want to list products which are acutally in stock.
If Salesperson Amy's note says "Sold" then this product would be considerd as Sold. (Even if Salesperson jack says "Reserved")
And I also want to remove all duplicates. Thank you so much for your help.
https://docs.google.com/spreadsheets/d/1Ax1MdRFnxisMYJqfoLWsP6Cm75bC51Ga2QvGjdAemnU/edit?usp=sharing
Solution
use:
=INDEX(UNIQUE(QUERY({B2:D, C2:C&D2:D}, "select Col1 where Col4 contains 'Sold'")))
update:
=UNIQUE(FILTER(B2:B, NOT(REGEXMATCH(B2:B,
TEXTJOIN("|", 1, INDEX(UNIQUE(QUERY({B2:D, C2:C&D2:D},
"select Col1 where Col4 contains 'Sold'"))))))))
- how to import data from one google sheet to another google sheet without appscript
- How to wait for an HTTPrequest response
- Normalize Google Sheet table (1st step)
- Google Apps Script BatchUpdate appending single apostrophe to output
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- How to calculate value based on tax bracket using Google sheet formula?
- Google script to dynamically addressing a cell in google sheet
- Add 95 to a cell if the name and date in that row match another row with the same name and date
- Auto numbering rows in GoogleSheet
- Error message while automating data entry from web app contact form to google sheet
- How do I send email to user by appending my domain name to the user name in Google Apps Script?
- How to split comma-separated values across multiple rows dynamically?
- Replace multiple strings in Google Spreadsheet with script
- How to count the amount of times a substring appears in a range of cells?
- Query with multiple data types
- Count If Range Matches Lookup in another tab
- Google Sheets Query where data in either of two columns matches the value in a cell populated by a multi-select dropdown
- Trying to combine words and math in a single cell in google sheets
- Counting the previous sample over multiple conditions throughout the range
- How to randomly select by type probability all items from a google sheet column range
- Sort result of function by RHS column
- Google Sheets Query - using another query to filter dates
- Skip formula if sheet does not exist in Google Sheets
- How to get data from public google sheet and more than 100 rows
- In Google sheets how can I Script the manipulation of the default Zoom?
- Google Sheets IMPORTDATA for xlsx files
- conditional formatting to highlight the highest value in a row compared to all the columns before it
- Google sheets summation formula, iterating until a new header on column A
- Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block
- How to scroll to bottom of a google spreadsheet using selenium