Need Only Number Which are not duplicate

Hi All,

we have two different columns and there are multiple number, we just want to all the number which are not duplicate.

Column A Column B
56 64
32 48
64 56
48 10
95 18
64 95

Result Are = 32, 10, 18

help pls

Try this:

=IFERROR(AGGREGATE(15,6,$A$2:$B$7/(COUNTIF($A$2:$B$7,$A$2:$B$7)=1),ROWS($E$2:E2)),"")

Thanks Phuocam,

we have large data from A2:B2007, what changed required in above formula

Change to:

=IFERROR(AGGREGATE(15,6,$A$2:$B$2007/(COUNTIF($A$2:$B$2007,$A$2:$B$2007)=1),ROWS($E$2:E2)),"")

thank you Phuocam,

with this formula, we will get all the number which are not duplicate, m i right?

Yes, you can test it.