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))
=IFERROR(VLOOKUP(D3,B$3:B$15,1,0),D3)Is this what you want to do? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
OliverScheurich: I fear my questions weren't really clearly enough, so I think you've provided a valid answer to a different problem from that which I was clumsily trying to frame.
But I do appreciate the care and work that every answer represents, so many thanks for taking the trouble to answer.
But I do appreciate the care and work that every answer represents, so many thanks for taking the trouble to answer.