Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare and replace values
Hello,
Here is my problem. I've got a set of values in one excel sheet (th results of a survey), some columns represents the results of a choic in a list of checkbox. Here is my checkbox list : 1. Toto 2. Tata 3. Titi My result file give me the position number 1, 2, 3 instead of the tex value toto, tata, titi. And I can't change anything in the form tha give this result. So, what I want to do, is to replace the 1, 2, 3 by their text value in excel. I've got a sheet with my imported data results, and a sheet with th list of my checkbox choice (one column with the text, one column wit the corresponding number). How can I parse my results sheet, to replace the numbers with th correponding text ? Any function doing that ? Or macro ? Ok, it's working with a long "IF" function, but it's not reusable a all if I change the number of checkbox choice (for an other survey with the same kind of template), etc. Thanks. Baste -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare values and replace | New Users to Excel | |||
Q: compare and replace in a workbook | Excel Worksheet Functions | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |