Em Andamento

Excel VBA Sorting Routine

Dear All,

I need help with a sorting routine that has specific requirements:

Take a table that is n rows long and m columns wide. This contains numbers that reflect sizes of shoes. This data wasn't given, but I can create some if you wish.

This program should read the first column of this data that is n rows long and m columns wide, and enter this data into an array that is also n rows long, but 1 column wide.

Then this program should create 2 new arrays, I and Y. Y is an array that is the sorted array where the smallest shoe size appears as the first element of the array. I is an array where it contains the rank of the shoe sizes, but the location of the rank in the array reflects the location of the shoe sizes that are in the original array. IMPORTANT: The original array should NOT be changed. And do NOT sort the entire column. Instead, take the smallest 10 shoe sizes and then sort them from smallest to largest., and the output should be for the smallest 10 sizes ONLY.

As an example:

X():

5

9

7

10

Y():

5

7

9

10

I():

1

3

2

4

## Deliverables

1) Complete and fully-functional working program(s) in Excel spreadsheet form as well as complete source code of all work done.

## Platform

Windows, EXCEL VBA

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Arquitetura de software, Teste de Software, Visual Basic, Word

Ver mais: vba sorting, vba work, vba with, sorting routine, sort array, smallest element data, element 14, excel vba long, excel vba help, need help excel, visual basic form excel, sort excel, excel data sorting, excel contains, spreadsheet vba code, windows vba, php table array, vba help, excel spreadsheet source code, vba example code work, excel array, php excel read, php excel array, sorting data, vba data form

Acerca do Empregador:
( 16 comentários ) Toronto, Canada

ID do Projeto: #2997438

Premiar a:

rolandanderson

See private message.

$15 USD em 3 dias
(5 Avaliações)
3.2

4 freelancers estão ofertando em média $14 para este trabalho

peterjl

See private message.

$17 USD in 3 dias
(75 Comentários)
5.3
aspxwarrior

See private message.

$17 USD in 3 dias
(10 Comentários)
2.8
ignatvw

See private message.

$8.5 USD in 3 dias
(3 Comentários)
1.5