In Progress

Macro for use with Excel 2000

We run Excel spreadsheets and use the basic sort function frequently, however it does not meet all our needs. Hence this request for a macro.

We would like the ability to be able to select a number of cells (a maximum of 40) in a column and convert the numbers in those cells into an order ranking (low to high), but leaving the order of the cells unchanged. Thus if the contents of selected cells M4, M5, M6, M7 and M8 were 3.5, 7.2, 1.4, 10.8 and 2.9, we would like to be able to use a macro to generate the following result M4 3, M5 4, M6 1, M7 5, M8 2. Once the macro had been applied, we need the column to sort as normal should the data in another column be re-sorted using the basic Excel sort function.

Notes

1. The contents of the cells to be converted into a rank order are always positive numbers to one decimal place, from 0.1 to 100.0.

2. Sometimes within a run of selected cells two or more will have the same number entered. When this occurs we would like the result to be as follows: if the contents of selected cells M4, M5, M6, M7 and M8 were 3.5, 7.2, 1.4, 10.8 and 3.5, we would like the macro to generate the following result M4 2=, M5 4, M6 1, M7 5, M8 2=.

3. We would like the macro to work in any column of the spreadsheet, not just one specified column.

Skills: Data Entry, Visual Basic

See more: excel 2000 sort macro, we excel, sort function c, numbers function, function numbers, excel &, data entry macro, c sort function, project 2000 problem sort macro, sorting macro excell 2000, visual basic excel 2000 notes, run macro day excel, excel macro sort function, excel 2000 simple sort macro, data entry as low as, Visual Basic Excel, Use, sort excel, macro, macro excel, macro + excel, m7, excel\ , excel, excel function

About the Employer:
( 34 reviews ) Harrow, United Kingdom

Project ID: #251236

Awarded to:

hiratariq

Hi, Please see PM.

$35 USD in 1 day
(9 Reviews)
4.1

15 freelancers are bidding on average $36 for this job

best4best

I got the trick, Please see PMB.

$50 USD in 2 days
(98 Reviews)
5.7
rajanlengde

I can do it well, See PMB

$50 USD in 2 days
(28 Reviews)
5.1
imranamin

Lets start

$20 USD in 1 day
(7 Reviews)
5.0
northwolves

As an expert of EXCEL,I'm lookingforward to work with you,see PMB please.

$20 USD in 0 days
(46 Reviews)
4.9
SergeyPlus

Hello. I can do it. Sergey.

$30 USD in 1 day
(10 Reviews)
4.4
vapinfocis

please refer pmb

$30 USD in 2 days
(2 Reviews)
2.4
Elgran

Hi, I am ready to do this for you. I am good in excel macro programing. Thanks.

$20 USD in 1 day
(0 Reviews)
0.0
anwar035

Dear Sir, Your requirements are quite straight-forward. I clearly understood what you want. I can do it ASAP. I am new in this site but have similar experiences in other freelancing sites. I am eager to work at More

$20 USD in 1 day
(0 Reviews)
0.0
pbsinfotech

We can do it. please contact me. It's very simple work. Thanks, Selvaraj B.

$10 USD in 0 days
(1 Review)
0.0
shahidsabir1

i understand what u mean, so tht project not a problem for me and for my team, looking for a chance.

$40 USD in 2 days
(0 Reviews)
0.0
rabilal

I will complete this task in 2 days.

$25 USD in 2 days
(0 Reviews)
0.0
sheikhasif

I have hardworker and experienced team. You can give me sample work free. Then decide for deal.

$100 USD in 10 days
(0 Reviews)
0.0
Kan630

Hello My name is Antoine. I am a french freelance programmer specialized with VBA. We can design and I can code the macro you want within a couple of hours Check out [url removed, login to view] to More

$50 USD in 1 day
(0 Reviews)
0.0
chimirala

I am proficient in excel macro..

$40 USD in 1 day
(0 Reviews)
0.0