Filtro De Filas Y Columnas

  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Filtro De Filas Y Columnas as PDF for free.

More details

  • Words: 358
  • Pages: 4
Pais España Francia Alemania Suiza Holanda Portugal Austria Grecia Belgica Polonia Suecia Chequia Andorra UK Irlanda Bulgaria Rumania Vacia

Dato1 2 74,479.29 3 47,381.88 50,678.98 4 5 18,274.70 18,480.25 6 7 5,431.44 4,859.90 8 6,126.88 9 10 9,213.52 11 3,305.84 1,862.64 12 365.88 13 46,163.66 14 1550,000.00 46,315.80 16 37,027.54 17 6,000.00 18 0.00 19

Dato2 B

117,335.29 86,830.88 88,878.98 54,044.70 30,190.25 11,354.84 9,030.70 10,916.98 10,735.52 3,229.94 2,753.64 748.78 46,163.66 50,000.00 46,315.80 37,027.54 6,000.00 0.00

Dato3 C Dato4 D Dato5 E F Dato6 G 99,398.49 57,194.72 156,593.21 10,077.4 63,234.86 52,647.80 115,882.66 3,336.4 67,635.10 50,980.92 118,616.02 7,073.3 24,389.03 47,737.89 72,126.92 3,469.9 24,663.35 15,627.92 40,291.27 2,108.6 7,248.69 7,905.24 15,153.93 800.7 6,485.92 5,566.26 12,052.18 600.6 8,176.80 6,392.77 14,569.57 934.2 12,296.17 2,031.23 14,327.40 1,201.1 4,411.90 -101.29 4,310.61 373.7 2,485.84 1,189.11 3,674.95 266.9 488.30 511.01 999.31 17.3 61,609.05 0.00 61,609.05 0.0 66,728.95 0.00 66,728.95 0.0 61,812.09 0.00 61,812.09 0.0 49,416.17 0.00 49,416.17 0.0 8,007.47 0.00 8,007.47 934.2 0.00 0.00 0.00 0.0

Aquí los datos la base de datos esta formada en función de la fila 1,2,3 y de la column a A, B, C que detecta en base

Dato7

Dato8 H 11,885.8 759.4 9,100.5 3,267.0 3,535.3 990.1 657.3 884.3 1,278.5 386.9 294.0 49.1 0.0 0.0 0.0 0.0 850.8 0.0

I 8,318.4 4,223.9 5,523.8 4,022.4 2,112.6 1,156.8 749.8 766.8 1,298.5 399.7 215.4 -18.6 2,791.9 0.0 0.0 0.0 905.9 0.0

ue detecta en base automaticamente la posición

Dato2 Dato7 C Dato4H Dato8 E suma p Iej 1º y 2" columna España 2 117,335.29 11,885.76 57,194.72 8,318.43 129,221.05 Francia 3 86,830.88 759.38 52,647.80 4,223.94 759.38 Holanda 6 30,190.25 3,535.30 15,627.92 2,112.64 3,535.30 Vacia 19 0.00 0.00 0.00 0.00 0.00 Rumania 18 6,000.00 850.79 0.00 905.91 850.79 Vacia 19 0.00 0.00 0.00 0.00 0.00 Vacia 19 0.00 0.00 0.00 0.00 0.00 Vacia 19 0.00 0.00 0.00 0.00 0.00 Vacia 19 0.00 0.00 0.00 0.00 0.00 Vacia 19 0.00 0.00 0.00 0.00 0.00 Vacia 19 0.00 0.00 0.00 0.00 0.00 240,356.42 17,031.23 125,470.44 15,560.92 134,366.52 Filtro

Aquí se puede filtrar por columna o fila Se puede escoger la fila y la columna y mostrar solo estas Sumar o cualquier tipo de operación

p ej 1º y 2" columna

Related Documents

Filas
June 2020 6
Columnas
August 2019 50
Filas
December 2019 15
Filtro
April 2020 28