I have two columns with numbers in them. I found a formula that extracts a unique list of the numbers in these two columns.
For example, if 3202 is present in column 0, but not present in column P, then the formula will show 3202 in column Q (Q is where the formula is). If 7102 is present in both columns O and P, then the formula will show 7102 in column Q only once.
The formula I have works perfectly except one little annoying issue. It leaves the first cell with the formula blank. I would expect my first result to appear in the first cell where I have the formula, but it doesn't work that way. How can I fix the formula so that the first instance of a unique number appears in the first cell in which I have entered the formula?
See attached for reference. Note, I would expect the first result (7302) to appear in cell Q4.
Additional detials (which are obvious once you open the attachment):
Column O header is in cell O3, and data below it is in cells O4:O24
Column P header is in cell P3, and data below it is in cells P4:P24
Column Q header is in cell Q3, and formula below it is in cells Q4:Q24
Formula is: =IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($Q$3:Q3,$O$4:$O$24)=0), $O$4:$O$24), LOOKUP(2, 1/(COUNTIF($Q$3:Q3, $P$4:$P$24)=0), $P$4:$P$24)),"")
If I change it as follows, it works 100% perfect, but it isn't like the example I found, and I just want to know if there is potential for issues with my alteration:
=IFERROR(IFERROR(LOOKUP(2, 1/(COUNTIF($Q$2:Q3,$O$4:$O$24)=0), $O$4:$O$24), LOOKUP(2, 1/(COUNTIF($Q$2:Q3, $P$4:$P$24)=0), $P$4:$P$24)),"")
Thank you!
Bookmarks