P Peo Sjoblom Oct 15, 2005 #2 Quick fix would be to apply data>advanced filter, unique entries only and copy to another location -- Regards, Peo Sjoblom (No private emails please)
Quick fix would be to apply data>advanced filter, unique entries only and copy to another location -- Regards, Peo Sjoblom (No private emails please)
P Paul Smith Oct 18, 2005 #3 Quick fix would be to apply data>advanced filter, unique entries only and copy to another location Click to expand... Try that with the Column A 1 1 2 The result will be same as the initial column. However, it does not happen if one replaces the second one with 2. Have I found a bug? Paul
Quick fix would be to apply data>advanced filter, unique entries only and copy to another location Click to expand... Try that with the Column A 1 1 2 The result will be same as the initial column. However, it does not happen if one replaces the second one with 2. Have I found a bug? Paul
P Peo Sjoblom Oct 18, 2005 #4 You need a header, Excel sees 1 as a header, try Numbers 1 1 2 and it will work
P Paul Smith Oct 18, 2005 #5 You need a header, Excel sees 1 as a header, try Numbers 1 1 2 and it will work Click to expand... Yes, it works! Thanks, Peo. Paul
You need a header, Excel sees 1 as a header, try Numbers 1 1 2 and it will work Click to expand... Yes, it works! Thanks, Peo. Paul
