OK…. Let me simplify, simplify and let’s see if you can assist me…or point me in the right direction: Say for example you have a "three column" spreadsheet in Excel.... Subcategory Outlet Sales I want to write a macro that will perform the following over the attached dataset: For subcategory1, for Outlet1: Calculate mean, median and standard deviation for Sales greater than $1 Take natural logarithm of all Sales greater than $1 any Sales greater than (mean + 4*standard deviation) redefine as (mean + 4*standard deviation) redefine all negative or missing values to the calculated mean. Loop to next: For subcategory1, for Outlet2: Do this for every Outlet…. Do this for every Subcategory So, the end will be a new “column” in the spreadsheet named ZSales…this is the new defined Sales by the macro… Is this possible??? May I ask you to help me write this??
... View more