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 working in 365:
=LET(b,B3:B15,d,D3:D15,SORT(FILTER(d,ISERROR(MATCH(d,b,0))),1,1))
=LET(b,B3:B15,d,D3:D15,SORT(FILTER(d,ISERROR(MATCH(d,b,0))),1,1))
Patrick2788: Apologies for not thanking you sooner -- fixed both my requirements in one go. I can paste it into any old column and it works exactly as I wanted -- although I haven't yet got my head around how it works, I'm sure I'll figure it out, given time.
Many thanks for amazingly quick and effective answer.
Many thanks for amazingly quick and effective answer.