BaseSecundarioSep2006 - VF.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | |||

2 | Mnemotcnico | Emisor | Precio | Rentabilidad % EA | Valor nominal (pesos) | Volumen (pesos) | Tipo | Tipo de Tasa | ||

3 | BDCU2999CVA | DPTO DE CUNDINAMARCA | 500,000,000 | 605,478,500.00 | IPC | |||||

4 | BDCU2999CVA | DPTO DE CUNDINAMARCA | 1,450,000,000 | 1,633,928,150.00 | IPC | |||||

5 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 1,000,000,000 | 1,072,001,000.00 | 0.00% | |||||

6 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 1,000,000,000 | 1,111,651,000.00 | 0.00% | |||||

7 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 200,000,000 | 222,330,200.00 | 0.00% | |||||

8 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 200,000,000 | 221,300,200.00 | 0.00% | |||||

9 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 200,000,000 | 221,398,200.00 | 0.00% | |||||

10 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 500,000,000 | 602,810,500.00 | 0.00% | |||||

11 | BDCU2999CVB | DPTO DE CUNDINAMARCA | 500,000,000 | 561,530,500.00 | 0.00% | |||||

12 | BDIT03180307 | BOGOTA D.C. | 2,000,000,000 | 2,052,854,000.00 | TF | |||||

13 | BDIT03180307 | BOGOTA D.C. | 1,000,000,000 | 1,026,547,000.00 | TF | |||||

CONTINUO PUBLICO |

The list goes on for aproximately 5000 rows. If you look at the first column, you will notice that some of the values repeat themselves.

I need excel to show me a list on another sheet but without repeating the same values over and over, in other words, I need a list of UNIQUE values for that column.

An example would be this result list on another sheet:

BaseSecundarioSep2006 - VF.xls | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

2 | Mnemotcnico | Emisor | Precio | Rentabilidad % EA | ||

3 | BDCU2999CVA | DPTO DE CUNDINAMARCA | ||||

4 | BDCU2999CVB | DPTO DE CUNDINAMARCA | ||||

5 | BDIT03180307 | BOGOTA D.C. | ||||

6 | BDIT04230909 | BOGOTA D.C. | ||||

7 | BDVT07150510 | BOGOTA D.C. | ||||

8 | BEPB102B9VA | EPM BOGOTA | ||||

CONTINUO PUBLICO |

Thanks for your help!!!