sortinggoogle-sheetsfilterflattentextjoin
Remove duplicates, with a increasing counter
I have a list, green is the unfiltered data. I tried using SORTN function to remove the duplicates indicated by the incrementing "Counter" column. Found a few solutions online that pointed me towards using something like
=sortn(sort(I2:N,2,0),rows(J2:J),1,2,0)
But I can't get it to remove the extra data, I made a seperate sheet with the desired results. ANy help is appreciated. I thought of using a Query function but I couldnt get it to work either.
https://docs.google.com/spreadsheets/d/1tDrbC_RizrQiEqa8Z0J0Gk9Ji3sHWUTRdJnKE748S-0/edit?usp=sharing
Solution
try:
=FILTER(A3:H, REGEXMATCH(B3:B&" "&C3:C&" "&H3:H,
JOIN("|", FLATTEN(QUERY(TRANSPOSE(
SORTN(SORT({B3:C, H3:H}, 3, 0), 9^9, 2, 2, 0)),,9^9)))))
- Reusable sort-function in PowerShell
- How to sort Data Table like FogBugz cases table
- Sort a 2d array by a column and obey a dynamic direction variable
- Sort a flat array ascending
- Can quicksort be implemented in C without stack and recursion?
- Sort rows of a 2d array by its first column descending
- Sort rows of a 2d array by address column prioritizing street name, then odd street numbers before evens, then street numbers
- Sort rows of a 2d array by a column's leading number so that odd numbers come before even numbers
- Sort MySQL query data by calculated values
- Sort a flat array to alternate values
- Worst scenario for shell sort: Θ(N^3/2) or O((NlogN)^2)?
- Best way to randomize an array with .NET
- Sort columns of numpy unitary matrix such that highest element of each column is on the diagonal
- Sort shopping list based on previous shopping trips
- Linux 'ls -ltr' sort by name
- How does 'ls' sort filenames?
- Why is the cutoff value to insertion sort for small sub-arrays in optimizing quicksort algorithm is system-dependent?
- How is result of 'random' function connected with list index?
- Custom sorting a flat array with uasort() returns 1
- Sort items in a multidimensional array by the best ranking item in a column's subarray using an array of ranked values
- Creating new String with sorted letters from a String word in Java
- Rotate an array of objects so that an object with a specific property is the first element
- How to stable-sort a flat array by each string's trailing integer
- Custom sort the keys of a flat associative array
- Google Apps Script sort stopped working "Exception: This operation is not supported on a table header row."
- Alphabetically sorting strings
- Sort the keys inside of each row of a 2d array
- Recursive key sorting function is not affecting lower level items
- (PHP) specific array sort
- Sort a multi-dim array by a column