Ejemplo 1:

Filtre la lista sin mover para seleccionar los registros del VENDEDOR Piero con CANTIDADES mayores a
CANTIDADES menores a 20.

Rango de Criterios Vendedor Cantidad

Colocarlosiempre

Reporte de Ventas

Nº Pedido Fecha Mes Sucursal Vendedor Código Articulo

21 1/6/2007 January Surco Piero P2-001 Post-it 5X8

21 1/6/2007 January Surco Piero P1-001 Post-it 5X5
21 1/6/2007 January Surco Piero D1-001 CD-R Sony 700 MB
21 1/6/2007 January Surco Piero L1-001 Lápiz Nº 2 Faber Castel
21 1/6/2007 January Surco Piero P3-001 Post-it 3X3
21 1/6/2007 January Surco Piero S1-001 Sobre Manila A4
22 1/16/2007 January Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
22 1/16/2007 January Surco Fabián D1-001 CD-R Sony 700 MB
22 1/16/2007 January Surco Fabián P3-001 Post-it 3X3
22 1/16/2007 January Surco Fabián S1-001 Sobre Manila A4
22 1/16/2007 January Surco Fabián P1-001 Post-it 5X5
22 1/16/2007 January Surco Fabián P2-001 Post-it 5X8
26 1/25/2007 January Surco Fabián P1-001 Post-it 5X5
23 1/26/2007 January Surco Piero D1-001 CD-R Sony 700 MB
23 1/26/2007 January Surco Piero P2-001 Post-it 5X8
23 1/26/2007 January Surco Piero L1-001 Lápiz Nº 2 Faber Castel
23 1/26/2007 January Surco Piero P1-001 Post-it 5X5
23 1/26/2007 January Surco Piero P3-001 Post-it 3X3
23 1/26/2007 January Surco Piero S1-001 Sobre Manila A4
24 2/5/2007 February Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
24 2/5/2007 February Surco Fabián S1-001 Sobre Manila A4
24 2/5/2007 February Surco Fabián D1-001 CD-R Sony 700 MB
24 2/5/2007 February Surco Fabián P3-001 Post-it 3X3
24 2/5/2007 February Surco Fabián P2-001 Post-it 5X8
24 2/5/2007 February Surco Fabián P1-001 Post-it 5X5
25 2/15/2007 February Surco Piero P1-001 Post-it 5X5
25 2/15/2007 February Surco Piero P3-001 Post-it 3X3
25 2/15/2007 February Surco Piero S1-001 Sobre Manila A4
25 2/15/2007 February Surco Piero L1-001 Lápiz Nº 2 Faber Castel
25 2/15/2007 February Surco Piero D1-001 CD-R Sony 700 MB
25 2/15/2007 February Surco Piero P2-001 Post-it 5X8
26 2/25/2007 February Surco Fabián P3-001 Post-it 3X3
26 2/25/2007 February Surco Fabián S1-001 Sobre Manila A4
26 2/25/2007 February Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
26 2/25/2007 February Surco Fabián D1-001 CD-R Sony 700 MB
26 2/25/2007 February Surco Fabián P2-001 Post-it 5X8
27 3/6/2007 March Surco Piero D1-001 CD-R Sony 700 MB
27 3/6/2007 March Surco Piero P3-001 Post-it 3X3
27 3/6/2007 March Surco Piero P2-001 Post-it 5X8
27 3/6/2007 March Surco Piero L1-001 Lápiz Nº 2 Faber Castel
27 3/6/2007 March Surco Piero P1-001 Post-it 5X5
27 3/6/2007 March Surco Piero S1-001 Sobre Manila A4
28 3/16/2007 March Surco Fabián D1-001 CD-R Sony 700 MB
28 3/16/2007 March Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
28 3/16/2007 March Surco Fabián P1-001 Post-it 5X5
28 3/16/2007 March Surco Fabián P3-001 Post-it 3X3
28 3/16/2007 March Surco Fabián P2-001 Post-it 5X8
28 3/16/2007 March Surco Fabián S1-001 Sobre Manila A4
29 3/26/2007 March Surco Piero P2-001 Post-it 5X8
29 3/26/2007 March Surco Piero S1-001 Sobre Manila A4
29 3/26/2007 March Surco Piero D1-001 CD-R Sony 700 MB
29 3/26/2007 March Surco Piero L1-001 Lápiz Nº 2 Faber Castel
29 3/26/2007 March Surco Piero P3-001 Post-it 3X3
29 3/26/2007 March Surco Piero P1-001 Post-it 5X5
30 4/5/2007 April Surco Fabián P1-001 Post-it 5X5
30 4/5/2007 April Surco Fabián D1-001 CD-R Sony 700 MB
30 4/5/2007 April Surco Fabián P3-001 Post-it 3X3
30 4/5/2007 April Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
30 4/5/2007 April Surco Fabián P2-001 Post-it 5X8
30 4/5/2007 April Surco Fabián S1-001 Sobre Manila A4
1 6/20/2007 June Lima Josué L1-001 Lápiz Nº 2 Faber Castel
1 6/20/2007 June Lima Josué P3-001 Post-it 3X3
1 6/20/2007 June Lima Josué P1-001 Post-it 5X5
1 6/20/2007 June Lima Josué D1-001 CD-R Sony 700 MB
1 6/20/2007 June Lima Josué P2-001 Post-it 5X8
1 6/20/2007 June Lima Josué S1-001 Sobre Manila A4
2 6/30/2007 June Lima Elías D1-001 CD-R Sony 700 MB
2 6/30/2007 June Lima Elías L1-001 Lápiz Nº 2 Faber Castel
2 6/30/2007 June Lima Elías P1-001 Post-it 5X5
2 6/30/2007 June Lima Elías P3-001 Post-it 3X3
2 6/30/2007 June Lima Elías P2-001 Post-it 5X8
2 6/30/2007 June Lima Elías S1-001 Sobre Manila A4
3 7/10/2007 July Lima Josué P3-001 Post-it 3X3
3 7/10/2007 July Lima Josué S1-001 Sobre Manila A4
3 7/10/2007 July Lima Josué L1-001 Lápiz Nº 2 Faber Castel
3 7/10/2007 July Lima Josué P2-001 Post-it 5X8
3 7/10/2007 July Lima Josué D1-001 CD-R Sony 700 MB
3 7/10/2007 July Lima Josué P1-001 Post-it 5X5
4 7/20/2007 July Lima Elías P2-001 Post-it 5X8
4 7/20/2007 July Lima Elías L1-001 Lápiz Nº 2 Faber Castel
4 7/20/2007 July Lima Elías P1-001 Post-it 5X5
4 7/20/2007 July Lima Elías S1-001 Sobre Manila A4
4 7/20/2007 July Lima Elías D1-001 CD-R Sony 700 MB
4 7/20/2007 July Lima Elías P3-001 Post-it 3X3
5 7/30/2007 July Lima Josué P1-001 Post-it 5X5
5 7/30/2007 July Lima Josué L1-001 Lápiz Nº 2 Faber Castel
5 7/30/2007 July Lima Josué P3-001 Post-it 3X3
5 7/30/2007 July Lima Josué S1-001 Sobre Manila A4
5 7/30/2007 July Lima Josué D1-001 CD-R Sony 700 MB
5 7/30/2007 July Lima Josué P2-001 Post-it 5X8
6 8/9/2007 August Lima Elías P1-001 Post-it 5X5
6 8/9/2007 August Lima Elías P2-001 Post-it 5X8
6 8/9/2007 August Lima Elías D1-001 CD-R Sony 700 MB
6 8/9/2007 August Lima Elías L1-001 Lápiz Nº 2 Faber Castel
6 8/9/2007 August Lima Elías P3-001 Post-it 3X3
6 8/9/2007 August Lima Elías S1-001 Sobre Manila A4
7 8/19/2007 August Lima Josué D1-001 CD-R Sony 700 MB
7 8/19/2007 August Lima Josué L1-001 Lápiz Nº 2 Faber Castel
7 8/19/2007 August Lima Josué P1-001 Post-it 5X5
7 8/19/2007 August Lima Josué S1-001 Sobre Manila A4
7 8/19/2007 August Lima Josué P3-001 Post-it 3X3
7 8/19/2007 August Lima Josué P2-001 Post-it 5X8
8 8/29/2007 August Lima Elías P1-001 Post-it 5X5
8 8/29/2007 August Lima Elías P3-001 Post-it 3X3
8 8/29/2007 August Lima Elías S1-001 Sobre Manila A4
8 8/29/2007 August Lima Elías L1-001 Lápiz Nº 2 Faber Castel
8 8/29/2007 August Lima Elías D1-001 CD-R Sony 700 MB
8 8/29/2007 August Lima Elías P2-001 Post-it 5X8
9 9/8/2007 September Miraflores Alberto P3-001 Post-it 3X3
9 9/8/2007 September Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
9 9/8/2007 September Miraflores Alberto P1-001 Post-it 5X5
9 9/8/2007 September Miraflores Alberto S1-001 Sobre Manila A4
9 9/8/2007 September Miraflores Alberto D1-001 CD-R Sony 700 MB
9 9/8/2007 September Miraflores Alberto P2-001 Post-it 5X8
10 9/18/2007 September Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
10 9/18/2007 September Miraflores Daniel P2-001 Post-it 5X8
10 9/18/2007 September Miraflores Daniel S1-001 Sobre Manila A4
10 9/18/2007 September Miraflores Daniel D1-001 CD-R Sony 700 MB
10 9/18/2007 September Miraflores Daniel P1-001 Post-it 5X5
10 9/18/2007 September Miraflores Daniel P3-001 Post-it 3X3
11 9/28/2007 September Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
11 9/28/2007 September Miraflores Alberto P2-001 Post-it 5X8
11 9/28/2007 September Miraflores Alberto D1-001 CD-R Sony 700 MB
11 9/28/2007 September Miraflores Alberto P1-001 Post-it 5X5
11 9/28/2007 September Miraflores Alberto S1-001 Sobre Manila A4
11 9/28/2007 September Miraflores Alberto P3-001 Post-it 3X3
12 10/8/2007 October Miraflores Daniel P2-001 Post-it 5X8
12 10/8/2007 October Miraflores Daniel P1-001 Post-it 5X5
12 10/8/2007 October Miraflores Daniel S1-001 Sobre Manila A4
12 10/8/2007 October Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
12 10/8/2007 October Miraflores Daniel D1-001 CD-R Sony 700 MB
13 10/18/2007 October Miraflores Alberto P3-001 Post-it 3X3
13 10/18/2007 October Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
13 10/18/2007 October Miraflores Alberto P2-001 Post-it 5X8
13 10/18/2007 October Miraflores Alberto D1-001 CD-R Sony 700 MB
13 10/18/2007 October Miraflores Alberto P1-001 Post-it 5X5
13 10/18/2007 October Miraflores Alberto S1-001 Sobre Manila A4
14 10/28/2007 October Miraflores Daniel P1-001 Post-it 5X5
14 10/28/2007 October Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
14 10/28/2007 October Miraflores Daniel D1-001 CD-R Sony 700 MB
14 10/28/2007 October Miraflores Daniel P3-001 Post-it 3X3
14 10/28/2007 October Miraflores Daniel P2-001 Post-it 5X8
15 11/7/2007 November Miraflores Alberto P2-001 Post-it 5X8
15 11/7/2007 November Miraflores Alberto P1-001 Post-it 5X5
15 11/7/2007 November Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
15 11/7/2007 November Miraflores Alberto D1-001 CD-R Sony 700 MB
15 11/7/2007 November Miraflores Alberto P3-001 Post-it 3X3
16 11/17/2007 November Miraflores Daniel P1-001 Post-it 5X5
16 11/17/2007 November Miraflores Daniel S1-001 Sobre Manila A4
16 11/17/2007 November Miraflores Daniel P3-001 Post-it 3X3
16 11/17/2007 November Miraflores Daniel D1-001 CD-R Sony 700 MB
16 11/17/2007 November Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
16 11/17/2007 November Miraflores Daniel P2-001 Post-it 5X8
17 11/27/2007 November Miraflores Alberto S1-001 Sobre Manila A4
17 11/27/2007 November Miraflores Alberto P3-001 Post-it 3X3
17 11/27/2007 November Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
17 11/27/2007 November Miraflores Alberto P2-001 Post-it 5X8
17 11/27/2007 November Miraflores Alberto D1-001 CD-R Sony 700 MB
17 11/27/2007 November Miraflores Alberto P1-001 Post-it 5X5
18 12/7/2007 December Miraflores Daniel P2-001 Post-it 5X8
18 12/7/2007 December Miraflores Daniel P1-001 Post-it 5X5
18 12/7/2007 December Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
18 12/7/2007 December Miraflores Daniel S1-001 Sobre Manila A4
18 12/7/2007 December Miraflores Daniel P3-001 Post-it 3X3
18 12/7/2007 December Miraflores Daniel D1-001 CD-R Sony 700 MB
19 12/17/2007 December Surco Piero P2-001 Post-it 5X8
19 12/17/2007 December Surco Piero S1-001 Sobre Manila A4
19 12/17/2007 December Surco Piero D1-001 CD-R Sony 700 MB
19 12/17/2007 December Surco Piero L1-001 Lápiz Nº 2 Faber Castel
19 12/17/2007 December Surco Piero P3-001 Post-it 3X3
19 12/17/2007 December Surco Piero P1-001 Post-it 5X5
20 12/27/2007 December Surco Fabián D1-001 CD-R Sony 700 MB
20 12/27/2007 December Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
20 12/27/2007 December Surco Fabián P3-001 Post-it 3X3
20 12/27/2007 December Surco Fabián P1-001 Post-it 5X5
20 12/27/2007 December Surco Fabián P2-001 Post-it 5X8
CANTIDADES mayores a 40, o los del VENDEDOR Fabián con

Cada y es otra columna

Colocarlosiempre encima de la base de datos

Unidad Precio Cantidad Ventas Comisión

Unitario
Bolsa x 10 15.00 50 750.00 30.00
Bolsa x 10 12.00 40 480.00 19.20
Caja x 10 2.50 30 75.00 3.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 10.00 30 300.00 12.00
Ciento 25.00 30 750.00 30.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 12.00 50 600.00 24.00
Caja x 10 2.50 40 100.00 4.00
Bolsa x 10 15.00 40 600.00 24.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Caja x 12 3.00 40 120.00 4.80
Ciento 25.00 40 1,000.00 40.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 15.00 30 450.00 18.00
Bolsa x 10 12.00 20 240.00 7.20
Bolsa x 10 12.00 50 600.00 24.00
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 10 150.00 4.50
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 15.00 30 450.00 18.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 12.00 20 240.00 7.20
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 10 150.00 4.50
Ciento 25.00 10 250.00 7.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 12.00 40 480.00 19.20
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 12.00 30 360.00 14.40
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 10 250.00 7.50
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 10 250.00 7.50
Bolsa x 10 10.00 50 500.00 20.00
Ciento 25.00 50 1,250.00 50.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 15.00 40 600.00 24.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 12.00 40 480.00 19.20
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 10.00 30 300.00 12.00
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 15.00 30 450.00 18.00
Caja x 10 2.50 20 50.00 1.50
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 45 540.00 21.60
Ciento 25.00 30 750.00 30.00
Bolsa x 10 10.00 55 550.00 22.00
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 12.00 50 600.00 24.00
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Ciento 25.00 40 1,000.00 40.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 60 900.00 36.00
Bolsa x 10 12.00 50 600.00 24.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 30 300.00 12.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Caja x 10 2.50 10 25.00 0.75
Bolsa x 10 12.00 10 120.00 3.60
Ciento 25.00 10 250.00 7.50
Bolsa x 10 12.00 40 480.00 19.20
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 15.00 70 1,050.00 42.00
Bolsa x 10 12.00 50 600.00 24.00
Caja x 12 3.00 40 120.00 4.80
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 12.00 50 600.00 24.00
Ciento 25.00 50 1,250.00 50.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 10 2.50 30 75.00 3.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 50 1,250.00 50.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 15.00 30 450.00 18.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 12.00 20 240.00 7.20
Bolsa x 10 15.00 60 900.00 36.00
Bolsa x 10 12.00 50 600.00 24.00
Caja x 12 3.00 40 120.00 4.80
Ciento 25.00 40 1,000.00 40.00
Bolsa x 10 10.00 30 300.00 12.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 15.00 10 150.00 4.50
Ejemplo 2: Filtre la lista copiando a partir de la celda A188 el resultado de seleccionar los registros de la SUCURSAL Lima con VENTAS
500 y 1000, o los de la SUCURSAL de Surco con VENTAS entre 400 y 800.

Rango de Criterios Sucursal Ventas Ventas

Reporte de Ventas

Nº Pedido Fecha Mes Sucursal Vendedor Código Articulo

1 6/20/2007 June Lima Josué L1-001 Lápiz Nº 2 Faber Castel

1 6/20/2007 June Lima Josué P3-001 Post-it 3X3
1 6/20/2007 June Lima Josué P1-001 Post-it 5X5
1 6/20/2007 June Lima Josué D1-001 CD-R Sony 700 MB
1 6/20/2007 June Lima Josué P2-001 Post-it 5X8
1 6/20/2007 June Lima Josué S1-001 Sobre Manila A4
2 6/30/2007 June Lima Elías D1-001 CD-R Sony 700 MB
2 6/30/2007 June Lima Elías L1-001 Lápiz Nº 2 Faber Castel
2 6/30/2007 June Lima Elías P1-001 Post-it 5X5
2 6/30/2007 June Lima Elías P3-001 Post-it 3X3
2 6/30/2007 June Lima Elías P2-001 Post-it 5X8
2 6/30/2007 June Lima Elías S1-001 Sobre Manila A4
3 7/10/2007 July Lima Josué P3-001 Post-it 3X3
3 7/10/2007 July Lima Josué S1-001 Sobre Manila A4
3 7/10/2007 July Lima Josué L1-001 Lápiz Nº 2 Faber Castel
3 7/10/2007 July Lima Josué P2-001 Post-it 5X8
3 7/10/2007 July Lima Josué D1-001 CD-R Sony 700 MB
3 7/10/2007 July Lima Josué P1-001 Post-it 5X5
4 7/20/2007 July Lima Elías P2-001 Post-it 5X8
4 7/20/2007 July Lima Elías L1-001 Lápiz Nº 2 Faber Castel
4 7/20/2007 July Lima Elías P1-001 Post-it 5X5
4 7/20/2007 July Lima Elías S1-001 Sobre Manila A4
4 7/20/2007 July Lima Elías D1-001 CD-R Sony 700 MB
4 7/20/2007 July Lima Elías P3-001 Post-it 3X3
5 7/30/2007 July Lima Josué P1-001 Post-it 5X5
5 7/30/2007 July Lima Josué L1-001 Lápiz Nº 2 Faber Castel
5 7/30/2007 July Lima Josué P3-001 Post-it 3X3
5 7/30/2007 July Lima Josué S1-001 Sobre Manila A4
5 7/30/2007 July Lima Josué D1-001 CD-R Sony 700 MB
5 7/30/2007 July Lima Josué P2-001 Post-it 5X8
6 8/9/2007 August Lima Elías P1-001 Post-it 5X5
6 8/9/2007 August Lima Elías P2-001 Post-it 5X8
6 8/9/2007 August Lima Elías D1-001 CD-R Sony 700 MB
6 8/9/2007 August Lima Elías L1-001 Lápiz Nº 2 Faber Castel
6 8/9/2007 August Lima Elías P3-001 Post-it 3X3
6 8/9/2007 August Lima Elías S1-001 Sobre Manila A4
7 8/19/2007 August Lima Josué D1-001 CD-R Sony 700 MB
7 8/19/2007 August Lima Josué L1-001 Lápiz Nº 2 Faber Castel
7 8/19/2007 August Lima Josué P1-001 Post-it 5X5
7 8/19/2007 August Lima Josué S1-001 Sobre Manila A4
7 8/19/2007 August Lima Josué P3-001 Post-it 3X3
7 8/19/2007 August Lima Josué P2-001 Post-it 5X8
8 8/29/2007 August Lima Elías P1-001 Post-it 5X5
8 8/29/2007 August Lima Elías P3-001 Post-it 3X3
8 8/29/2007 August Lima Elías S1-001 Sobre Manila A4
8 8/29/2007 August Lima Elías L1-001 Lápiz Nº 2 Faber Castel
8 8/29/2007 August Lima Elías D1-001 CD-R Sony 700 MB
8 8/29/2007 August Lima Elías P2-001 Post-it 5X8
9 9/8/2007 September Miraflores Alberto P3-001 Post-it 3X3
9 9/8/2007 September Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
9 9/8/2007 September Miraflores Alberto P1-001 Post-it 5X5
9 9/8/2007 September Miraflores Alberto S1-001 Sobre Manila A4
9 9/8/2007 September Miraflores Alberto D1-001 CD-R Sony 700 MB
9 9/8/2007 September Miraflores Alberto P2-001 Post-it 5X8
10 9/18/2007 September Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
10 9/18/2007 September Miraflores Daniel P2-001 Post-it 5X8
10 9/18/2007 September Miraflores Daniel S1-001 Sobre Manila A4
10 9/18/2007 September Miraflores Daniel D1-001 CD-R Sony 700 MB
10 9/18/2007 September Miraflores Daniel P1-001 Post-it 5X5
10 9/18/2007 September Miraflores Daniel P3-001 Post-it 3X3
11 9/28/2007 September Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
11 9/28/2007 September Miraflores Alberto P2-001 Post-it 5X8
11 9/28/2007 September Miraflores Alberto D1-001 CD-R Sony 700 MB
11 9/28/2007 September Miraflores Alberto P1-001 Post-it 5X5
11 9/28/2007 September Miraflores Alberto S1-001 Sobre Manila A4
11 9/28/2007 September Miraflores Alberto P3-001 Post-it 3X3
12 10/8/2007 October Miraflores Daniel P2-001 Post-it 5X8
12 10/8/2007 October Miraflores Daniel P1-001 Post-it 5X5
12 10/8/2007 October Miraflores Daniel S1-001 Sobre Manila A4
12 10/8/2007 October Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
12 10/8/2007 October Miraflores Daniel D1-001 CD-R Sony 700 MB
13 10/18/2007 October Miraflores Alberto P3-001 Post-it 3X3
13 10/18/2007 October Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
13 10/18/2007 October Miraflores Alberto P2-001 Post-it 5X8
13 10/18/2007 October Miraflores Alberto D1-001 CD-R Sony 700 MB
13 10/18/2007 October Miraflores Alberto P1-001 Post-it 5X5
13 10/18/2007 October Miraflores Alberto S1-001 Sobre Manila A4
14 10/28/2007 October Miraflores Daniel P1-001 Post-it 5X5
14 10/28/2007 October Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
14 10/28/2007 October Miraflores Daniel D1-001 CD-R Sony 700 MB
14 10/28/2007 October Miraflores Daniel P3-001 Post-it 3X3
14 10/28/2007 October Miraflores Daniel P2-001 Post-it 5X8
15 11/7/2007 November Miraflores Alberto P2-001 Post-it 5X8
15 11/7/2007 November Miraflores Alberto P1-001 Post-it 5X5
15 11/7/2007 November Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
15 11/7/2007 November Miraflores Alberto D1-001 CD-R Sony 700 MB
15 11/7/2007 November Miraflores Alberto P3-001 Post-it 3X3
16 11/17/2007 November Miraflores Daniel P1-001 Post-it 5X5
16 11/17/2007 November Miraflores Daniel S1-001 Sobre Manila A4
16 11/17/2007 November Miraflores Daniel P3-001 Post-it 3X3
16 11/17/2007 November Miraflores Daniel D1-001 CD-R Sony 700 MB
16 11/17/2007 November Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
16 11/17/2007 November Miraflores Daniel P2-001 Post-it 5X8
17 11/27/2007 November Miraflores Alberto S1-001 Sobre Manila A4
17 11/27/2007 November Miraflores Alberto P3-001 Post-it 3X3
17 11/27/2007 November Miraflores Alberto L1-001 Lápiz Nº 2 Faber Castel
17 11/27/2007 November Miraflores Alberto P2-001 Post-it 5X8
17 11/27/2007 November Miraflores Alberto D1-001 CD-R Sony 700 MB
17 11/27/2007 November Miraflores Alberto P1-001 Post-it 5X5
18 12/7/2007 December Miraflores Daniel P2-001 Post-it 5X8
18 12/7/2007 December Miraflores Daniel P1-001 Post-it 5X5
18 12/7/2007 December Miraflores Daniel L1-001 Lápiz Nº 2 Faber Castel
18 12/7/2007 December Miraflores Daniel S1-001 Sobre Manila A4
18 12/7/2007 December Miraflores Daniel P3-001 Post-it 3X3
18 12/7/2007 December Miraflores Daniel D1-001 CD-R Sony 700 MB
19 12/17/2007 December Surco Piero P2-001 Post-it 5X8
19 12/17/2007 December Surco Piero S1-001 Sobre Manila A4
19 12/17/2007 December Surco Piero D1-001 CD-R Sony 700 MB
19 12/17/2007 December Surco Piero L1-001 Lápiz Nº 2 Faber Castel
19 12/17/2007 December Surco Piero P3-001 Post-it 3X3
19 12/17/2007 December Surco Piero P1-001 Post-it 5X5
20 12/27/2007 December Surco Fabián D1-001 CD-R Sony 700 MB
20 12/27/2007 December Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
20 12/27/2007 December Surco Fabián P3-001 Post-it 3X3
20 12/27/2007 December Surco Fabián P1-001 Post-it 5X5
20 12/27/2007 December Surco Fabián P2-001 Post-it 5X8
21 1/6/2007 January Surco Piero P2-001 Post-it 5X8
21 1/6/2007 January Surco Piero P1-001 Post-it 5X5
21 1/6/2007 January Surco Piero D1-001 CD-R Sony 700 MB
21 1/6/2007 January Surco Piero L1-001 Lápiz Nº 2 Faber Castel
21 1/6/2007 January Surco Piero P3-001 Post-it 3X3
21 1/6/2007 January Surco Piero S1-001 Sobre Manila A4
22 1/16/2007 January Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
22 1/16/2007 January Surco Fabián D1-001 CD-R Sony 700 MB
22 1/16/2007 January Surco Fabián P3-001 Post-it 3X3
22 1/16/2007 January Surco Fabián S1-001 Sobre Manila A4
22 1/16/2007 January Surco Fabián P1-001 Post-it 5X5
22 1/16/2007 January Surco Fabián P2-001 Post-it 5X8
23 1/26/2007 January Surco Piero D1-001 CD-R Sony 700 MB
23 1/26/2007 January Surco Piero P2-001 Post-it 5X8
23 1/26/2007 January Surco Piero L1-001 Lápiz Nº 2 Faber Castel
23 1/26/2007 January Surco Piero P1-001 Post-it 5X5
23 1/26/2007 January Surco Piero P3-001 Post-it 3X3
23 1/26/2007 January Surco Piero S1-001 Sobre Manila A4
24 2/5/2007 February Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
24 2/5/2007 February Surco Fabián S1-001 Sobre Manila A4
24 2/5/2007 February Surco Fabián D1-001 CD-R Sony 700 MB
24 2/5/2007 February Surco Fabián P3-001 Post-it 3X3
24 2/5/2007 February Surco Fabián P2-001 Post-it 5X8
24 2/5/2007 February Surco Fabián P1-001 Post-it 5X5
25 2/15/2007 February Surco Piero P1-001 Post-it 5X5
25 2/15/2007 February Surco Piero P3-001 Post-it 3X3
25 2/15/2007 February Surco Piero S1-001 Sobre Manila A4
25 2/15/2007 February Surco Piero L1-001 Lápiz Nº 2 Faber Castel
25 2/15/2007 February Surco Piero D1-001 CD-R Sony 700 MB
25 2/15/2007 February Surco Piero P2-001 Post-it 5X8
26 1/25/2007 January Surco Fabián P1-001 Post-it 5X5
26 2/25/2007 February Surco Fabián P3-001 Post-it 3X3
26 2/25/2007 February Surco Fabián S1-001 Sobre Manila A4
26 2/25/2007 February Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
26 2/25/2007 February Surco Fabián D1-001 CD-R Sony 700 MB
26 2/25/2007 February Surco Fabián P2-001 Post-it 5X8
27 3/6/2007 March Surco Piero D1-001 CD-R Sony 700 MB
27 3/6/2007 March Surco Piero P3-001 Post-it 3X3
27 3/6/2007 March Surco Piero P2-001 Post-it 5X8
27 3/6/2007 March Surco Piero L1-001 Lápiz Nº 2 Faber Castel
27 3/6/2007 March Surco Piero P1-001 Post-it 5X5
27 3/6/2007 March Surco Piero S1-001 Sobre Manila A4
28 3/16/2007 March Surco Fabián D1-001 CD-R Sony 700 MB
28 3/16/2007 March Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
28 3/16/2007 March Surco Fabián P1-001 Post-it 5X5
28 3/16/2007 March Surco Fabián P3-001 Post-it 3X3
28 3/16/2007 March Surco Fabián P2-001 Post-it 5X8
28 3/16/2007 March Surco Fabián S1-001 Sobre Manila A4
29 3/26/2007 March Surco Piero P2-001 Post-it 5X8
29 3/26/2007 March Surco Piero S1-001 Sobre Manila A4
29 3/26/2007 March Surco Piero D1-001 CD-R Sony 700 MB
29 3/26/2007 March Surco Piero L1-001 Lápiz Nº 2 Faber Castel
29 3/26/2007 March Surco Piero P3-001 Post-it 3X3
29 3/26/2007 March Surco Piero P1-001 Post-it 5X5
30 4/5/2007 April Surco Fabián P1-001 Post-it 5X5
30 4/5/2007 April Surco Fabián D1-001 CD-R Sony 700 MB
30 4/5/2007 April Surco Fabián P3-001 Post-it 3X3
30 4/5/2007 April Surco Fabián L1-001 Lápiz Nº 2 Faber Castel
30 4/5/2007 April Surco Fabián P2-001 Post-it 5X8
30 4/5/2007 April Surco Fabián S1-001 Sobre Manila A4
de la SUCURSAL Lima con VENTAS entre

Precio
Unidad Unitario Cantidad Ventas Comisión

Caja x 12 3.00 30 90.00 3.60

Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 12.00 30 360.00 14.40
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 10 250.00 7.50
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 10 250.00 7.50
Bolsa x 10 10.00 50 500.00 20.00
Ciento 25.00 50 1,250.00 50.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 15.00 40 600.00 24.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 12.00 40 480.00 19.20
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 10.00 30 300.00 12.00
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 15.00 30 450.00 18.00
Caja x 10 2.50 20 50.00 1.50
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 45 540.00 21.60
 Ciento 25.00 30 750.00 30.00
Bolsa x 10 10.00 55 550.00 22.00
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 12.00 50 600.00 24.00
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Ciento 25.00 40 1,000.00 40.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Caja x 12 3.00 40 120.00 4.80
Bolsa x 10 15.00 40 600.00 24.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 12.00 30 360.00 14.40
Ciento 25.00 30 750.00 30.00
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 60 900.00 36.00
Bolsa x 10 12.00 50 600.00 24.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 30 300.00 12.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Caja x 10 2.50 10 25.00 0.75
Bolsa x 10 12.00 10 120.00 3.60
Ciento 25.00 10 250.00 7.50
Bolsa x 10 12.00 40 480.00 19.20
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 15.00 70 1,050.00 42.00
Bolsa x 10 12.00 50 600.00 24.00
Caja x 12 3.00 40 120.00 4.80
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 12.00 50 600.00 24.00
 Ciento 25.00 50 1,250.00 50.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 10 2.50 30 75.00 3.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 50 1,250.00 50.00
Bolsa x 10 10.00 40 400.00 16.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 15.00 30 450.00 18.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 12.00 20 240.00 7.20
Bolsa x 10 15.00 60 900.00 36.00
Bolsa x 10 12.00 50 600.00 24.00
Caja x 12 3.00 40 120.00 4.80
Ciento 25.00 40 1,000.00 40.00
Bolsa x 10 10.00 30 300.00 12.00
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 15.00 50 750.00 30.00
Bolsa x 10 12.00 40 480.00 19.20
Caja x 10 2.50 30 75.00 3.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 10.00 30 300.00 12.00
Ciento 25.00 30 750.00 30.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 15.00 10 150.00 4.50
Caja x 10 2.50 40 100.00 4.00
Bolsa x 10 15.00 40 600.00 24.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Ciento 25.00 20 500.00 15.00
Caja x 12 3.00 40 120.00 4.80
Ciento 25.00 40 1,000.00 40.00
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 15.00 30 450.00 18.00
Bolsa x 10 12.00 20 240.00 7.20
Bolsa x 10 12.00 50 600.00 24.00
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 10 150.00 4.50
Bolsa x 10 12.00 50 600.00 24.00
Bolsa x 10 10.00 40 400.00 16.00
Ciento 25.00 40 1,000.00 40.00
Caja x 12 3.00 30 90.00 3.60
Caja x 10 2.50 20 50.00 1.50
Bolsa x 10 15.00 10 150.00 4.50
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Bolsa x 10 15.00 30 450.00 18.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 12.00 20 240.00 7.20
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 40 100.00 4.00
Caja x 12 3.00 30 90.00 3.60
Bolsa x 10 12.00 30 360.00 14.40
Bolsa x 10 10.00 20 200.00 6.00
Bolsa x 10 15.00 10 150.00 4.50
Ciento 25.00 10 250.00 7.50
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
Caja x 10 2.50 10 25.00 0.75
Caja x 12 3.00 10 30.00 0.90
Bolsa x 10 10.00 10 100.00 3.00
Bolsa x 10 12.00 10 120.00 3.60
Bolsa x 10 12.00 40 480.00 19.20
Caja x 10 2.50 30 75.00 3.00
Bolsa x 10 10.00 30 300.00 12.00
Caja x 12 3.00 20 60.00 1.80
Bolsa x 10 15.00 20 300.00 9.00
Ciento 25.00 20 500.00 15.00
 Filtre la lista copiando a partir de la celda D188 el resultado de seleccionar los registros con VENTAS a partir de 100, cuyo
Ejemplo 3: carácter del CÓDIGO sea 1 y que la UNIDAD de medida sea Caja. Adicionalmente para la copia debe considerar únicame
columnas Fecha, Vendedor, Código, Artículo, Unidad y Ventas.

Rango de Criterios Ventas Código Unidad

>=100 ?1* Caja*

Reporte de Ventas

Nº Pedido Fecha Mes Sucursal Vendedor Código

1 6/20/2007 June Lima Josué D1-001

2 6/30/2007 June Lima Elías D1-001
3 7/10/2007 July Lima Josué D1-001
4 7/20/2007 July Lima Elías D1-001
5 7/30/2007 July Lima Josué D1-001
6 8/9/2007 August Lima Elías D1-001
7 8/19/2007 August Lima Josué D1-001
8 8/29/2007 August Lima Elías D1-001
9 9/8/2007 September Miraflores Alberto D1-001
10 9/18/2007 September Miraflores Daniel D1-001
11 9/28/2007 September Miraflores Alberto D1-001
12 10/8/2007 October Miraflores Daniel D1-001
13 10/18/2007 October Miraflores Alberto D1-001
14 10/28/2007 October Miraflores Daniel D1-001
15 11/7/2007 November Miraflores Alberto D1-001
16 11/17/2007 November Miraflores Daniel D1-001
17 11/27/2007 November Miraflores Alberto D1-001
18 12/7/2007 December Miraflores Daniel D1-001
19 12/17/2007 December Surco Piero D1-001
20 12/27/2007 December Surco Fabián D1-001
21 1/6/2007 January Surco Piero D1-001
22 1/16/2007 January Surco Fabián D1-001
23 1/26/2007 January Surco Piero D1-001
24 2/5/2007 February Surco Fabián D1-001
25 2/15/2007 February Surco Piero D1-001
26 2/25/2007 February Surco Fabián D1-001
27 3/6/2007 March Surco Piero D1-001
28 3/16/2007 March Surco Fabián D1-001
29 3/26/2007 March Surco Piero D1-001
30 4/5/2007 April Surco Fabián D1-001
1 6/20/2007 June Lima Josué L1-001
2 6/30/2007 June Lima Elías L1-001
3 7/10/2007 July Lima Josué L1-001
4 7/20/2007 July Lima Elías L1-001
5 7/30/2007 July Lima Josué L1-001
6 8/9/2007 August Lima Elías L1-001
7 8/19/2007 August Lima Josué L1-001
8 8/29/2007 August Lima Elías L1-001
9 9/8/2007 September Miraflores Alberto L1-001
10 9/18/2007 September Miraflores Daniel L1-001
11 9/28/2007 September Miraflores Alberto L1-001
12 10/8/2007 October Miraflores Daniel L1-001
13 10/18/2007 October Miraflores Alberto L1-001
14 10/28/2007 October Miraflores Daniel L1-001
15 11/7/2007 November Miraflores Alberto L1-001
16 11/17/2007 November Miraflores Daniel L1-001
17 11/27/2007 November Miraflores Alberto L1-001
18 12/7/2007 December Miraflores Daniel L1-001
19 12/17/2007 December Surco Piero L1-001
20 12/27/2007 December Surco Fabián L1-001
21 1/6/2007 January Surco Piero L1-001
22 1/16/2007 January Surco Fabián L1-001
23 1/26/2007 January Surco Piero L1-001
24 2/5/2007 February Surco Fabián L1-001
25 2/15/2007 February Surco Piero L1-001
26 2/25/2007 February Surco Fabián L1-001
27 3/6/2007 March Surco Piero L1-001
28 3/16/2007 March Surco Fabián L1-001
29 3/26/2007 March Surco Piero L1-001
30 4/5/2007 April Surco Fabián L1-001
1 6/20/2007 June Lima Josué P1-001
2 6/30/2007 June Lima Elías P1-001
3 7/10/2007 July Lima Josué P1-001
4 7/20/2007 July Lima Elías P1-001
5 7/30/2007 July Lima Josué P1-001
6 8/9/2007 August Lima Elías P1-001
7 8/19/2007 August Lima Josué P1-001
8 8/29/2007 August Lima Elías P1-001
9 9/8/2007 September Miraflores Alberto P1-001
10 9/18/2007 September Miraflores Daniel P1-001
11 9/28/2007 September Miraflores Alberto P1-001
12 10/8/2007 October Miraflores Daniel P1-001
13 10/18/2007 October Miraflores Alberto P1-001
14 10/28/2007 October Miraflores Daniel P1-001
15 11/7/2007 November Miraflores Alberto P1-001
16 11/17/2007 November Miraflores Daniel P1-001
17 11/27/2007 November Miraflores Alberto P1-001
18 12/7/2007 December Miraflores Daniel P1-001
19 12/17/2007 December Surco Piero P1-001
20 12/27/2007 December Surco Fabián P1-001
21 1/6/2007 January Surco Piero P1-001
22 1/16/2007 January Surco Fabián P1-001
23 1/26/2007 January Surco Piero P1-001
24 2/5/2007 February Surco Fabián P1-001
25 2/15/2007 February Surco Piero P1-001
26 1/25/2007 January Surco Fabián P1-001
27 3/6/2007 March Surco Piero P1-001
28 3/16/2007 March Surco Fabián P1-001
29 3/26/2007 March Surco Piero P1-001
30 4/5/2007 April Surco Fabián P1-001
1 6/20/2007 June Lima Josué P2-001
2 6/30/2007 June Lima Elías P2-001
3 7/10/2007 July Lima Josué P2-001
4 7/20/2007 July Lima Elías P2-001
5 7/30/2007 July Lima Josué P2-001
6 8/9/2007 August Lima Elías P2-001
7 8/19/2007 August Lima Josué P2-001
8 8/29/2007 August Lima Elías P2-001
9 9/8/2007 September Miraflores Alberto P2-001
10 9/18/2007 September Miraflores Daniel P2-001
11 9/28/2007 September Miraflores Alberto P2-001
12 10/8/2007 October Miraflores Daniel P2-001
13 10/18/2007 October Miraflores Alberto P2-001
14 10/28/2007 October Miraflores Daniel P2-001
15 11/7/2007 November Miraflores Alberto P2-001
16 11/17/2007 November Miraflores Daniel P2-001
17 11/27/2007 November Miraflores Alberto P2-001
18 12/7/2007 December Miraflores Daniel P2-001
19 12/17/2007 December Surco Piero P2-001
20 12/27/2007 December Surco Fabián P2-001
21 1/6/2007 January Surco Piero P2-001
22 1/16/2007 January Surco Fabián P2-001
23 1/26/2007 January Surco Piero P2-001
24 2/5/2007 February Surco Fabián P2-001
25 2/15/2007 February Surco Piero P2-001
26 2/25/2007 February Surco Fabián P2-001
27 3/6/2007 March Surco Piero P2-001
28 3/16/2007 March Surco Fabián P2-001
29 3/26/2007 March Surco Piero P2-001
30 4/5/2007 April Surco Fabián P2-001
1 6/20/2007 June Lima Josué P3-001
2 6/30/2007 June Lima Elías P3-001
3 7/10/2007 July Lima Josué P3-001
4 7/20/2007 July Lima Elías P3-001
5 7/30/2007 July Lima Josué P3-001
6 8/9/2007 August Lima Elías P3-001
7 8/19/2007 August Lima Josué P3-001
8 8/29/2007 August Lima Elías P3-001
9 9/8/2007 September Miraflores Alberto P3-001
10 9/18/2007 September Miraflores Daniel P3-001
11 9/28/2007 September Miraflores Alberto P3-001
13 10/18/2007 October Miraflores Alberto P3-001
14 10/28/2007 October Miraflores Daniel P3-001
15 11/7/2007 November Miraflores Alberto P3-001
 16 11/17/2007 November Miraflores Daniel P3-001
17 11/27/2007 November Miraflores Alberto P3-001
18 12/7/2007 December Miraflores Daniel P3-001
19 12/17/2007 December Surco Piero P3-001
20 12/27/2007 December Surco Fabián P3-001
21 1/6/2007 January Surco Piero P3-001
22 1/16/2007 January Surco Fabián P3-001
23 1/26/2007 January Surco Piero P3-001
24 2/5/2007 February Surco Fabián P3-001
25 2/15/2007 February Surco Piero P3-001
26 2/25/2007 February Surco Fabián P3-001
27 3/6/2007 March Surco Piero P3-001
28 3/16/2007 March Surco Fabián P3-001
29 3/26/2007 March Surco Piero P3-001
30 4/5/2007 April Surco Fabián P3-001
1 6/20/2007 June Lima Josué S1-001
2 6/30/2007 June Lima Elías S1-001
3 7/10/2007 July Lima Josué S1-001
4 7/20/2007 July Lima Elías S1-001
5 7/30/2007 July Lima Josué S1-001
6 8/9/2007 August Lima Elías S1-001
7 8/19/2007 August Lima Josué S1-001
8 8/29/2007 August Lima Elías S1-001
9 9/8/2007 September Miraflores Alberto S1-001
10 9/18/2007 September Miraflores Daniel S1-001
11 9/28/2007 September Miraflores Alberto S1-001
12 10/8/2007 October Miraflores Daniel S1-001
13 10/18/2007 October Miraflores Alberto S1-001
16 11/17/2007 November Miraflores Daniel S1-001
17 11/27/2007 November Miraflores Alberto S1-001
18 12/7/2007 December Miraflores Daniel S1-001
19 12/17/2007 December Surco Piero S1-001
21 1/6/2007 January Surco Piero S1-001
22 1/16/2007 January Surco Fabián S1-001
23 1/26/2007 January Surco Piero S1-001
24 2/5/2007 February Surco Fabián S1-001
25 2/15/2007 February Surco Piero S1-001
26 2/25/2007 February Surco Fabián S1-001
27 3/6/2007 March Surco Piero S1-001
28 3/16/2007 March Surco Fabián S1-001
29 3/26/2007 March Surco Piero S1-001
30 4/5/2007 April Surco Fabián S1-001

Fecha Vendedor Código Articulo Unidad Ventas

6/30/2007 Elías D1-001 CD-R Sony 700 MB Caja x 10 100.00
8/19/2007 Josué D1-001 CD-R Sony 700 MB Caja x 10 100.00
1/26/2007 Piero D1-001 CD-R Sony 700 MB Caja x 10 100.00
3/16/2007 Fabián D1-001 CD-R Sony 700 MB Caja x 10 100.00
7/10/2007 Josué L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
9/18/2007 Daniel L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
9/28/2007 Alberto L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
11/7/2007 Alberto L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
12/7/2007 Daniel L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
2/5/2007 Fabián L1-001 Lápiz Nº 2 Faber Castel Caja x 12 120.00
ccionar los registros con VENTAS a partir de 100, cuyo segundo
dicionalmente para la copia debe considerar únicamente las

DUO EXAMEN
* Busca cualquier numero de caracteres B2
? Varia un solo caracter B2-C1
<> No quiero que salgan determinados caracteres C1

Precio
Articulo Unidad Cantidad Ventas Comisión
Unitario
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 40 100.00 4.00
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 40 100.00 4.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 10 25.00 0.75
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 10 25.00 0.75
CD-R Sony 700 MB Caja x 10 2.50 10 25.00 0.75
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 40 100.00 4.00
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 20 50.00 1.50
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
CD-R Sony 700 MB Caja x 10 2.50 40 100.00 4.00
CD-R Sony 700 MB Caja x 10 2.50 10 25.00 0.75
CD-R Sony 700 MB Caja x 10 2.50 30 75.00 3.00
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 20 60.00 1.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 20 60.00 1.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 20 60.00 1.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 10 30.00 0.90
Lápiz Nº 2 Faber Castel Caja x 12 3.00 10 30.00 0.90
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 40 120.00 4.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 20 60.00 1.80
Lápiz Nº 2 Faber Castel Caja x 12 3.00 30 90.00 3.60
Lápiz Nº 2 Faber Castel Caja x 12 3.00 10 30.00 0.90
Lápiz Nº 2 Faber Castel Caja x 12 3.00 20 60.00 1.80
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 40 480.00 19.20
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 45 540.00 21.60
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 10 120.00 3.60
Post-it 5X5 Bolsa x 10 12.00 40 480.00 19.20
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 20 240.00 7.20
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 10 120.00 3.60
Post-it 5X5 Bolsa x 10 12.00 10 120.00 3.60
Post-it 5X5 Bolsa x 10 12.00 40 480.00 19.20
Post-it 5X5 Bolsa x 10 12.00 10 120.00 3.60
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 20 240.00 7.20
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 50 600.00 24.00
Post-it 5X5 Bolsa x 10 12.00 20 240.00 7.20
Post-it 5X5 Bolsa x 10 12.00 30 360.00 14.40
Post-it 5X5 Bolsa x 10 12.00 10 120.00 3.60
Post-it 5X5 Bolsa x 10 12.00 40 480.00 19.20
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 40 600.00 24.00
Post-it 5X8 Bolsa x 10 15.00 40 600.00 24.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 30 450.00 18.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 40 600.00 24.00
Post-it 5X8 Bolsa x 10 15.00 40 600.00 24.00
Post-it 5X8 Bolsa x 10 15.00 60 900.00 36.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 70 1,050.00 42.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 30 450.00 18.00
Post-it 5X8 Bolsa x 10 15.00 60 900.00 36.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 50 750.00 30.00
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 40 600.00 24.00
Post-it 5X8 Bolsa x 10 15.00 30 450.00 18.00
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 30 450.00 18.00
Post-it 5X8 Bolsa x 10 15.00 10 150.00 4.50
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 5X8 Bolsa x 10 15.00 20 300.00 9.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 50 500.00 20.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 55 550.00 22.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 10 100.00 3.00
Post-it 3X3 Bolsa x 10 10.00 10 100.00 3.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 40 400.00 16.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Post-it 3X3 Bolsa x 10 10.00 20 200.00 6.00
Post-it 3X3 Bolsa x 10 10.00 10 100.00 3.00
Post-it 3X3 Bolsa x 10 10.00 30 300.00 12.00
Sobre Manila A4 Ciento 25.00 10 250.00 7.50
Sobre Manila A4 Ciento 25.00 10 250.00 7.50
Sobre Manila A4 Ciento 25.00 50 1,250.00 50.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 10 250.00 7.50
Sobre Manila A4 Ciento 25.00 50 1,250.00 50.00
Sobre Manila A4 Ciento 25.00 50 1,250.00 50.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 30 750.00 30.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 40 1,000.00 40.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 10 250.00 7.50
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
Sobre Manila A4 Ciento 25.00 20 500.00 15.00
 DUO EXAMEN
66.7
77.3 ME "85/110
83.3