Posted to microsoft.public.excel.programming

Jim May

external usenet poster

Posts: 430

Solve Using VBA Routine

I have a table: A1:C11 as follows (Cells C2:C11 are Blank), but Macro
should fill in answer (given to the right):

Name Amt Order Answer to Order (=Rank ascending by Name)
Jon 13 ? 1
Jon 23 ? 3
Jon 15 ? 2
Peter 27 ? 2
Peter 10 ? 1
Alex 23 ? 2
Alex 34 ? 3
Alex 18 ? 1
Alex 36 ? 4
Mary 15 ? 1

The VBA routine should fill in C2:C11 with the above #'s
Can someone help me along?
TIA,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sub routine	Gord Dibben	Excel Discussion (Misc queries)	0	November 13th 09 12:15 AM
Using (what goes in here) for sub routine	Wally Steadman[_4_]	Excel Programming	2	December 30th 04 06:51 PM
SUB ROUTINE	tokirk	Excel Programming	1	January 19th 04 02:17 AM
Routine??	Zax	Excel Programming	3	December 19th 03 05:50 PM
Need VBA Routine	John M. Lembo	Excel Programming	0	July 13th 03 01:51 AM

All times are GMT +1. The time now is 05:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us