This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Problem description & analysis:
An Excel table has two columns of numbers, and there are duplicates in a column:
Task: First remove duplicates from the columns and then compute their intersection:
Solution:
Use SPL XLL to do this:
=spl("=[?1,?2].isect(~.group().select(~.len()==1).conj())",A1:A5,B1:B4)
As shown in the picture below:
Explanation:
isect()computes the intersection. group() groups data but does not perform aggregation. select() performs filtering operation; ~ is the current member.
This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Judith-Excel-Sharing | Sciencx (2024-07-26T04:13:18+00:00) #34 — Remove Duplicates And Compute Intersection. Retrieved from https://www.scien.cx/2024/07/26/34-remove-duplicates-and-compute-intersection/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.