Hello,

I need your help! Please, help me...

In the MS Excel Worksheet Sheet1, Column A there are numbers 1, 2 & 3 which I change manualy and I need to add manualy another new numbers in combination with old numbers in Sheet1, Column A.

I need a MS Excel Worksheet formula (Please, no VBA) wich automaticall add numbers from the Sheet1, Column A to the Sheet2, Column A but not by duplicates in the Sheet2, Column A and automatically recognize a new added number 4 in the Sheet1, Column A as I type it and add automatically number 4 as the next in the Sheet2, Column A.

Sheet1 Sheet2
Column A Column A
1 1
2 2
3 3
1
2
3
3
2
2
1
3

Thank you in advance for your help and collaboration.
All the best of the best.
Regards,
Master