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,)))))))
- Allow script to edit locked cells
- How to join unique strings in their own column with QUERY?
- How do I use XLOOKUP for multiple criteria?
- How to use AppendRow
- How to code "Next Friday" in Google Sheets?
- How can I resolve this `Error: You must select all cells in a merged range to merge or unmerge them.` while merging cells through App Script?
- Casting method asTextItem throws error for Google form item
- Counting blank cells by arrayformula
- ARRAYFORMULA with GOOGLEFINANCE function
- Conditional formatting depending on two cells
- How do I find the highest sum of multiple cells in column A where the sum is based on multiple cells matching in column B in Google Sheets?
- Returning the last input entry
- Draw and filter Charts in App Script Web app
- Google Sheets - select "most recent " cell in a column and return corresponding value in same row
- Byrow formula with reference to last row and last column
- How Do I Give rows in a table of contents a key. Then look up the key Later using the data from the rows in table of contents?
- Duplicate whole spreadsheet using Google Sheets API
- Array Formula to omit certain values
- Google Sheets Query While Removing Duplicates
- NAME error hiperlink function Apps Script Google Sheets
- Three-dimensional referencing
- Can I use a named range as column headers?
- Trying to get Google App Script Code to Acknowledge Cells In A Column in Excel to do Individual Math
- How to get the price of a stock at a particular date from Google Finance?
- How to Split a String Up into Individual Characters
- How to integrating Google Sign-In into your google script web app
- Formula is currently double-counting a cell
- Get dropdown options in google sheets in table
- Search for targets and indicate where they come from
- One-to-one assignment in Google sheets with data validation