Put the different numbers in the two rows on the third row

Question

Put the different numbers in the two rows on the third row.

1 Row: 1 2 4 5 7

2 Row: 1 4 6 7 8

Result 3 Row: 2 5 6 8

Answer 1

Hi @BABY_JOJO,

Try this formula:

=IFERROR(SMALL(IF(COUNTIF(1:2,$A1:$Z2)=1,$A1:$Z2),COLUMN()),"")

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

In cell A5, enter this formula

=UNIQUE(TOROW(A2:E3),TRUE,TRUE)

Hope this helps.