LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default generating a rank order on two variables

Hello,
Is this possible...

I want excel to scan column A which contains course codes
some of which will be the same.
Then I want excel to compare the same course codes with
the corresponding entry date entered in Column B.
In column C I would like excel to generate a numbered
list base on same course code and the date entered.

This is basically a course waiting list that will assign
a priority number to an individual who wishes to be
placed on a course waiting list based on the date they
made the request.

Any suggestions are appreciated,

Rekoop
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Rank order of errors Derek Excel Worksheet Functions 1 November 19th 07 03:59 PM
Order/Rank Rod Excel Worksheet Functions 14 July 28th 07 11:00 PM
generating rank-ordered list [email protected] Excel Discussion (Misc queries) 4 November 13th 06 12:48 PM
Generating numbers in order with excel PLEASE HELP color1928 Excel Discussion (Misc queries) 2 July 30th 05 12:01 AM
Tie breaking in a rank order HondaMike Excel Worksheet Functions 1 December 29th 04 11:30 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"