| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I assign a numeric value to a text entry?
Okay.. It's been a while since I've had my Excel courses. Here's th scenario... I have a worksheet that is tracking 'points' for a real estate sale contest. Certain transactions performed with a property are 'worth more points than others. Here's an example of what the columns loo like: ------------ --------- -------------- ----------- ------------- -------------------- -------------- Address |-Sale-- |-Points: 1--|--Listing--|-Points: 2--|-In Hous Sale--|--Points:3-- ----------- -------- -------------- ----------- ------------- -------------------- -------------- 123 A St.| Joe S. |------1------ |-Jane S.--|------2------|---Jil S.------------|-----3------- ------------ -------- -------------- ----------- ------------- -------------------- -------------- 456 B St.|---------|--------------| Sally T. |------2 ------|--Dav R.---------|-----3-------- ------------- --------- --------------- ------------ -------------- --------------------- -------------- My question is: How do I formulate the 'Points' cells to automaticall populate with the correct number (1, 2, 3 points) just by typing tex (the salesperson's name) into the column beside it? ALSO, how do calculate all the points each salesperson has earned on anothe worksheet if their name appears in different columns and row throughout the worksheet (without doing =SUM ([and CTRL+clicking al the different cells]) )?? Please Help! -KL -- KathyDent197 ----------------------------------------------------------------------- KathyDent1976's Profile: http://www.excelforum.com/member.php...fo&userid=1501 View this thread: http://www.excelforum.com/showthread.php?threadid=26631 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign text to numeric value | Excel Discussion (Misc queries) | |||
| How do I assign a numeric value to a letter | Excel Worksheet Functions | |||
| How do I assign a numeric value to text? IE cell = yes then 1 | Excel Discussion (Misc queries) | |||
| Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
| How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
Threaded Mode
