Apr 12 2022 07:06 AM
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 in col. B that are missing from L2 items in col D.
But I can't find a way to do this all in col F, without needing an intermediate col F in order to get the result in col G.
I'm sure this must be easy, but can't make it work
2) The next step would be to get the results to display in consecutive rows instead of spaced out as currently in col G. I know I can do this by filtering the results or pasting as data into a separate column and then sorting it, but I'd like to know how to do it straight into my desired column...
Apr 12 2022 07:14 AM
=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.
Apr 12 2022 07:52 AM
SolutionApr 12 2022 08:21 AM
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,"")
Apr 13 2022 12:35 PM
Apr 13 2022 12:45 PM
Apr 13 2022 12:56 PM
Apr 13 2022 12:59 PM
Apr 12 2022 07:52 AM
Solution