View Single Post
  #1   Report Post  
Master
 
Posts: n/a
Default Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA


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


--
Master
------------------------------------------------------------------------
Master's Profile: http://www.excelforum.com/member.php...o&userid=25123
View this thread: http://www.excelforum.com/showthread...hreadid=386259