Hi All,
Have two columns.
I am trying to find out what values are in both column A and column B.
I would like to show in column C what values ARE NOT in both columns.
Please see attached for example.
Hi All,
Have two columns.
I am trying to find out what values are in both column A and column B.
I would like to show in column C what values ARE NOT in both columns.
Please see attached for example.
=IFERROR(INDIRECT(TEXT(SMALL(IF((COUNTIF(RNG,RNG)=1)*(COUNTIF($F$1:F1,RNG)=0),ROW(RNG)*10000+COLUMN(RNG)),ROWS($F2:F$2)-COUNTA($F$1:F1)),"R000000C0000"),0),"") as array formula
smth is wrong with data
i changed some values
RNG is a name for your range
Forestavekids
My contribution
Put the data in column A2 and B2 and in C2 put formula
=IFERROR(INDEX(A$2:A$161,MATCH(0,IF(ISNA(MATCH(A$2:A$161,B$2:B$161,0)),COUNTIF(C$1:C1,A$2:A$161)),0)),"")&""
Decio
deciog,
I can't seem to get this past row 160 in column C?
Last edited by jeffreybrown; 05-29-2017 at 07:21 PM. Reason: Removed full quote!
tim201110,
I can't seem to get this past row 160 in column C?
Last edited by jeffreybrown; 05-29-2017 at 07:21 PM. Reason: Removed full quote!
The formula is typed CTRL + SHIFT + ENTER
Decio
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks