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,)))))))
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- How to use Apps script to move a lot of data rows at same time to different spreadsheet automatically base on time
- How to ignore empty rows when submitting to database
- Custom Menus Google Apps Script
- Google Sheets Index Sidebar of all tabs - add search functionality
- How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
- Google script Display array with rows of different sizes
- List rows in array when the cell contain number in the string
- ImportXML XPath issue using Google Sheets on a simple web scraping query
- Return index of cell that contains match on two strings
- Conditional formatting if cell past date and another cell empty with arrayformula
- How to find the Second Space from the right in Google Sheets?
- Joining more than two WHERE statements in Query Language
- Python gspread create sheet if not exist
- Find if cell contents exist in array
- Google Apps Script: Finding an element in a Column and returning the corresponding row
- Active VS Effective User for Google Sheets
- Rearrange data in table format to rows
- I am not able to extract URL from these cell values using Google Apps Script
- How to count a specific word from a string in a cell from the entire column in google sheets
- Error returned by action script when calling an API with UrlFetchApp.fetch
- How can I make this formula more dynamic by including another criteria (cell F11) in the query?
- How to execute a Google Apps Script ONLY on the edited row
- How to copy the last row in one table and append to another table in the same GSheet (the same tab)
- Replace duplicate row with new data in Google Sheets using Apps Script
- In Google sheets, how does one either return a blank cell or perform a function based on another cells lack of content?
- Incorrect result of iferror formula via Apps Script
- How to Extract URLs from HYPERLINK in Google Sheets
- Using a reference cell as part of a column in a google sheets query