Em Andamento

Excel question

A very simple problem for an Excel guru. I would like to accomplish the following in an Excel spreadsheet using the Evaluate method.

I have a 3 column range expanding over 100 rows. I would like to take the value from column 1 and put it into some formula in Column 3 (same row) but rather than seeing the formula in the spreadsheet cell, I would like to "Evaluate" so that I only get the values in the cell and not the formula.

An example is Stock symbol and price.

All Stock symbols are in column 1 and I would like to use some stock function to bring in the price from some data source. I do not want to put the formula to do this in the 3rd column, instead I would like only the values to be shown based on the symbol in the corresponding 1st column.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Excel, Windows

Habilidades: Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic, Área de trabalho do Windows

Ver mais: windows guru, visual basic guru, row 44, price guru, guru symbols, guru method, basic guru, excel spreadsheet formula, visual basic form excel, excel guru, excel function, excel formula, excel formula spreadsheet spreadsheet, excel row column, excel formula condition, excel based software, excel spreadsheet source code, excel column row, excel cell, stock spreadsheet excel, stock excel, install visual basic excel, excel stock symbol price, column row excel, source function excel

Acerca do Empregador:
( 20 comentários ) JerseyCity, United States

ID do Projeto: #2972895

Premiar a:


See private message.

$7 USD em 1 dia
(316 Avaliações)

2 freelancers estão ofertando em média $6 para este trabalho


See private message.

$4.25 USD em 1 dia
(3 Comentários)