Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a macro to sort and replace data
ok. here is my question:
1. I have 16 columns with cells having values between 0 to 25. I want to substitute the values in this manner: if value is ‰¤3 then substitute it with 1. if value 3 ‰¤7 then substitute it with 2, and so on and so forth. the condition for each column will be different. for e.g. I may have a condition in column 2 where I would want value ‰¤ 5 substituted by 1 and 5 ‰¤ 8 substituted by 2, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to sort through data | Excel Programming | |||
Macro to replace data within a worksheet | Excel Worksheet Functions | |||
Macro based Import Data Inserts Cells, I want Replace | Excel Programming | |||
Using a MACRO to sort data | Excel Worksheet Functions | |||
data sort macro | Excel Programming |