#1
|
|||
|
|||
replace numbers with names
Hello, I have a table with days and tasks to do. Then another one with names and respective numbers. When I type a person's number in the task table, I would like excel to replace the number with the name of the person. Is this possible to do ? thank you for your help. |
#2
|
|||
|
|||
Can you accept that numbers are entered in for example rows 2:6 and then the corresponding names appear in rows 24:28?
|
#3
|
|||
|
|||
Or forget about the numbers entirely and just use a validation list for each cell in the table.
|
#4
|
|||
|
|||
Quote:
I've tried =INDEX($Q$1:$Q$14,MRAND()+1) functions, but notice it repeats ppl on the same task on the following day...so this is no good. |
#5
|
|||
|
|||
Does validation list pick random ppl to random tasks & doesn't repeat them ?
|
#6
|
|||
|
|||
If you in the attached file anywhere in A1:Z100 enter one of the numbers 1 to 8 Excel will automatically change that number to the corresponding name according to your list.
|
#7
|
|||
|
|||
Or with your layout in post #1 and a minor switch to the names...
|
Tags |
names, numbers, replace |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and replace BETWEEN numbers | WordUser2015 | Word | 4 | 12-19-2014 02:09 PM |
Replace 0000s with a series of numbers | tingker | Word VBA | 2 | 12-17-2014 06:06 AM |
Find and replace inside strings containing various names | audioman | Word VBA | 4 | 03-25-2014 11:19 AM |
find and replace consecutive numbers | kpl_39 | Word | 1 | 06-07-2013 05:04 AM |
Find & Replace formula for numbers? | Griff | Word | 4 | 04-18-2011 02:47 AM |