Excel formula

Question

Put different numbers from two rows on the third row.

Any suggestion is appreciated, thanks.

Answer 1

Hi,

Try this formula and drag to the right:

=IFERROR(SMALL(IF(COUNTIF(1:2,$A1:$I2)=1,$A1:$I2),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

Maybe you mean something like this: =IF(AND(ISBLANK(A1),ISBLANK(A2)),"",MAX(A1,A2)+1). Put it to A3.