View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dnganatra@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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.