Sort 2 columns without repeating

[deciog]

Dear friends,

Can you help me with a formula so that column E shows the sorted date without repeating between two columns A and C, not in VBA, formula Excel


Thank you in advance.

Décio

 

[bosco_yip]

Try………..

In F3, Ctrl+Shift+Enter formula copy down :

=IFERROR(SMALL(IF(CHOOSE({1,2},A$3:A$40,C$3:C$40)>0,CHOOSE({1,2},A$3:A$40,C$3:C$40)),SUMPRODUCT((CHOOSE({1,2},A$3:A$40,C$3:C$40)>0)*(CHOOSE({1,2},A$3:A$40,C$3:C$40)<=F2))+1),"")

Regards
Bosco

 

[deciog]

Wow, thank you, fantastic, it works perfectly.

Thank you very much

Decio

 

[John Jairo V]

Hi to all!

Another option (In E3, no CSE) :

=IFERROR(SMALL((A$3:A$40,C$3:C$40),1+SUMPRODUCT(COUNTIF(E$2:E2,CHOOSE({1,2},A$3:A$40,C$3:C$40)))),"")

Blessings!

 

[deciog]

John Jairo V, greetings

First thank the effort made, but the formula is not doing right, where I went wrong, check the attachment, I would like very non-matrix formula because the spreadsheet has almost 20,000 lines.

Decio

 

[John Jairo V]

Hi again!

Check your matrix constant separator. Is wrong!!

=IFERROR(SMALL((A$3:A$40,C$3:C$40),1+SUMPRODUCT(COUNTIF(E$2:E2,CHOOSE({1,2},A$3:A$40,C$3:C$40)))),"")

Blessings!

 

[deciog]

John Jairo V

Wow, thank you, fantastic, it works perfectly.

Thank you very much

Blessings!

Decio