Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by RememberTwoThings

I am working with a football roster in excel. I have 22 different positions listed on the roster. I would like to assign a number (1-22) to each position so that I can sort the roster in order by position. How can I do this? Thanks.

Hi, very much depends on what criteria you'll be using to sort.

I've built many sports related workbooks over the years so happy to help out here. But perhaps a little more information and an example workbook would help clarify what it is you need...

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
Assign numerical value to cell based on selection from drop-down m	Tim	Excel Discussion (Misc queries)	1	April 6th 10 08:11 PM
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL	teacherpaul	Excel Worksheet Functions	5	October 24th 06 02:35 PM
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc	Bob1023	Excel Worksheet Functions	1	July 26th 06 02:53 AM
ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003	legman	Excel Worksheet Functions	4	May 14th 06 04:09 AM
Assign numerical values to text codes	Bridget	Excel Worksheet Functions	3	April 18th 05 11:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us