ciao,ancora un altro problema con xl,
ho questa matrice in foglio1:
A B G V
sku Zone Invoice Date Invoiced Net Qty
8BR616 WTHF0FA6 Asia 26/10/2009 25
8BR616 WTHF0FA6 Asia 22/10/2009 8
8BR616 WTHF0FA6 Asia 26/10/2009 15
8BR616 WTHF0FA6 Europe 20/10/2009 1
8BR616 WTHF0FA6 Europe 20/10/2009 6
8BR616 WTHF0FA6 Europe 20/10/2009 1
8BR616 WTHF0FA6 Europe 19/10/2009 1
8BR616 WTHF0FA6 Europe 19/10/2009 7
8BR616 WTHF0FA6 Europe 19/10/2009 5
8BR616 WTHF0FA6 Europe 20/10/2009 2
8BR616 WTHF0FA6 Europe 20/10/2009 1
8BR616 WTHF0FA6 Europe 22/10/2009 2
8BR616 WTHF0FA6 Europe 22/10/2009 1
8BR616 WTHF0FA6 Europe 23/10/2009 1
8BR616 WTHF0FA6 Europe 20/10/2009 5
8BR616 WTHF0FA6 Japan 26/10/2009 5
8BR616 WTHF0FA6 Middle East 26/10/2009 4
8BR616 WTHF0FA6 Middle East 26/10/2009 3
8BR616 WTHF0FA6 Middle East 26/10/2009 5
vorrei ottenere in foglio2:
8BR616 WTHF0FA6 Asia 26/10/2009 25
8BR616 WTHF0FA6 Asia 26/10/2009 15
8BR616 WTHF0FA6 Japan 26/10/2009 5
8BR616 WTHF0FA6 Middle East 26/10/2009 4
8BR616 WTHF0FA6 Middle East 26/10/2009 3
8BR616 WTHF0FA6 Middle East 26/10/2009 5
8BR616 WTHF0FA6 Middle East 26/10/2009 3
come faccio?