How Get the Invoice Number and Range the number, Group by Sales Name

**antoni** · 07-13-2009, 03:21 AM

Hello, anyone can help me, I have a Sales Report and I want to Get the Invoice Number and Range the number, Group by Sales Name.

Like this :

Sales Report (SOURCE)
---------------------------------------------------
Date No. Invoice QTY Price Sales Name
---------------------------------------------------
01/02/09 001 2 $2 Jhon
01/02/09 002 1 $22 Bill
01/02/09 003 5 $52 Jhon
01/02/09 004 7 $12 Hanny
01/02/09 005 2 $2 Hanny
01/02/09 006 3 $20 Hanny
---------------------------------------------------

So, I want get the data like this (TARGET) :

---------------------------------------------------
Date No. Invoice Sales Name
---------------------------------------------------
01/02/09 001, 003 Jhon

---------------------------------------------------
Date No. Invoice Sales Name
---------------------------------------------------
01/02/09 002 Bill

---------------------------------------------------
Date No. Invoice Sales Name
---------------------------------------------------
01/02/09 004-006 Hanny

Thank's b4

**royUK** · 07-13-2009, 03:23 AM

The bst option would be a pivotTable or AutoFilter

**antoni** · 07-14-2009, 12:57 AM

Thank's Mr. Roy, but I think using a pivotTable or AutoFilter can make a mistake when input the data (group the inv. number). cause we must entry the data manually.

**royUK** · 07-14-2009, 03:01 AM

Originally Posted by antoni

Thank's Mr. Roy, but I think using a pivotTable or AutoFilter can make a mistake when input the data (group the inv. number). cause we must entry the data manually.

You don't use either to input he data, the only mistakes can be user mistakes when inputting.

You need to explain more carefully what you mean, maybe attach an example workbook