Forum Discussion
Common entry
Dear Experts, I need to prepare a list of rnti's in column "N" ( a parameter say) which is common in all these 4 Tables, may be with XMATCH , or any other formulae.. ...
If you have the FILTER function I suggest you use it! An alternative might be UNIQUE:
= LET(
list, SORT(TOCOL(data,1)),
distinct, UNIQUE(list),
unique, UNIQUE(list,,TRUE),
combined, VSTACK(distinct, unique),
UNIQUE(combined,,TRUE)
)What this does is bring all your data into a single sorted column. It then calculates every distinct value and appends the list of those occurring only once. Duplicates in the original list occur only once in the combined list and are easily identified using the final application of UNIQUE.