| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
De-identify data
Hello,
I'm new to this group I've got a "student names" column (about 3000 names) and a "student comments" column (about 23,000 comments). I would like to replace all names appearing in "student comments" entries with an X by matching with entries in "student names" column. Is there a way of automating this with an Excel function? I'm using Excel 2007 and am a "basic" Excel user. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Identify Col Data-Pairs that Differ by 2*pi | Excel Worksheet Functions | |||
| Identify last row of populated data | Excel Worksheet Functions | |||
| identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
| identify different data in two columns | Excel Discussion (Misc queries) | |||
| identify data in a cell that has a number as the second character | Excel Worksheet Functions | |||
Threaded Mode
