Forum Discussion
Solved
Compare unsorted columns without interim calculation
As an elderly Excel tyro, I'm trying to see differences between two unsorted columns. In the particular case (see dummy example screenshot), I have two aims: 1) In column G, I can show the L1 items...
- If working in 365:
=LET(b,B3:B15,d,D3:D15,SORT(FILTER(d,ISERROR(MATCH(d,b,0))),1,1))
If Excel 2021 or 365...
in F3:
=XLOOKUP(D3:D15,B3:B15,B3:B15,"")in G3:
=IF(ISNA(XMATCH(D3:D15,B3:B15)),D3:D15,"")Lorenzo : Apologies for not thanking you sooner for your answer. I probably didn't frame my questions clearly, so although it didn't seem to address my supplementary question, (as fixed by Patrick2788), your answer is valuable to me as it shows how to neatly display both sides of the comparison between headings L1 and L2. So I'll have to get familiar with XLOOKUP and XMATCH.
Thanks for taking the time to help.
Thanks for taking the time to help.