How do i check for & filter by multiple unique arguments in google sheets?
I currently am majually going through Google Sheet spreadsheets that include peoples' names, and charitable groups they've donated to, with each donation being a new line. I am currently trying to find a way to easily isolate just people who have donated to 2 or more charities, so i would need to use a formula/function that checks for unique names, and then searches rows with each unique name and shows/isolates/sorts only the rows where a specific individual has donated to more than one charity. The issue is that in many many cases, people donate to the same charity twice, so it can't just be # of instances of a given unique name.
I've attached a sample sheet that has all the info replaced with anonomized info but its effectively the same setup, plus an example of what data i want seperated. https://docs.google.com/spreadsheets/d/1heECQb9D9TzCAjQsU8-Ij1wUI-cZOsK-N3LXAGX3-Fo/edit?usp=sharing
Thank you in advance!
You may try:
=filter(A2:R25,let(Σ,Q2:Q25,xmatch(Σ,reduce(,unique(Σ),lambda(a,c,vstack(a,if(countuniqueifs(B2:B25,Σ,c)>1,c,)))))))
- Google App Script - Json response parsing
- Using INDIRECT in Google Sheets to reference to reference a table's named column
- Run a function published in Webapp from a Google site
- Querying a Google Sheet API using GViz
- How do you resolve a "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues" error
- How do i make 3 column to arrange in 1?
- Google Apps Script getBackgrounds for colour custom function
- Auto-change or Query function Google sheets
- What is the purpose of the "UPLUS()" function in Google Sheets?
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- How to extract the whole match and not just the captured group?
- Create connected drop-downs in google sheets where value can be present only in one drop-down
- Custom sort order according to cell value
- Find and print last edit dates of preexisting rows in a sheet (Google Sheets)
- Google Apps Script creates sheets version of excel file
- How to fix a #VALUE error when trying to pull an entire row of information from multiple sheets
- If var isnumber, for script
- Excel spill range reference in Google sheets
- Google Sheets Script new Date() with timezone is providing wrong time
- Trying to Email Multiple PDF Blobs in Sheets Javascript
- HTTP Google Sheets API v4 how to access without OAuth 2.0?
- List All Workdays between Start and End Dates Displaying Associated Name and Details in Other Columns
- How do I edit the response of a form submission in Google Forms/Sheets?
- How can I count repeats in a a column but reset count on non-repeats, in an array formula
- How do I stop Google AppScripts (Sheets) from creating two protected range entries
- Transfer Data from one sheet to another
- googlesheet get last non blank row from specific rows
- Send Mail after Form Submit to Google Sheet
- IFS with multiple conditions check in Google Sheet
- Can I find the value of a cell B49 that changes value according to the value of the cell F2 ( in Google sheet)