Em Andamento

macro subroutine to add data elements

Hi

Following is project description

Have a spreadsheet of 93K data elements. 1 column of 93K rows.

Need to add every 100 elements and multiply by 10, to create a result of 930 data points in another column.

In other words: Need Sum(1:99)*10, Sum(100:199)*10, and so on

Also need to graph(scatter plot) above data on y axis. x axis will correspond to row numbers.

For example data points for graph in (x,y) is (1, Sum(1:99)*10) (2, Sum(100:199)*10) and so on.

Need a macro/subroutine that can be used against another dataset.

Habilidades: Excel, Visual Basic

Ver mais: x-axis, data to graph, data on a graph, data in a graph, data for graph, data plot, scatter plot graph, macro spreadsheet, create macro project, macro add, add data, create macro, add spreadsheet, add points, sum numbers, plot graph, elements , macro add row data, scatter, graph data, spreadsheet add, create graph data, subroutine plot, import mpp data excel using macro, macro data spreadsheet

Acerca do Empregador:
( 1 comentário ) Somerset, United States

ID do Projeto: #5121288

Premiar a:

Teloquence

Hired by the Employer

$50 USD em 1 dia
(160 Avaliações)
6.5