LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 310
Default How do I assign a number to a name in another column?

Hello,

I am new to Excel. I need help assigning numbers to a group of names. I
have 2500 names to assign...don't really want to do it manually!

Example

# Name
100 John Smith
100 John Smith
100 John Smith
101 Adam Suken
101 Adam Suken
101 Adam Suken

and so on....

Thanks!

 
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
Assign a number to a word Noob McKnownowt Excel Worksheet Functions 5 September 16th 08 11:39 AM
Can I assign a number to a name and use the name in a sum? beeno Excel Discussion (Misc queries) 1 July 11th 06 10:47 PM
Assign one number to a number range Sue New Users to Excel 1 October 6th 05 01:21 AM
Assign a number to a name Sukismomma Excel Worksheet Functions 4 March 3rd 05 07:49 PM
looking to assign different numbers in column B to different words in column A mike Excel Worksheet Functions 2 January 13th 05 01:46 AM


All times are GMT +1. The time now is 04:33 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"