Anyone a whizz on excel? I’m willing to buy a beer for the - TopicsExpress



          

Anyone a whizz on excel? I’m willing to buy a beer for the first person who solves a problem for me! I have a column of data. I need to have a macro which compares each cell in the column with the cell immediately above it. If a cell is more than a set percentage (e.g. 25%)different from the previous data point, I need it to be deleted, and replaced by an average of the cells immediately above and below it. That formula needs to start at the top of the existing column of data and work it’s way DOWN to the bottom of it….
Posted on: Wed, 21 Aug 2013 20:40:42 +0000

Trending Topics



Recently Viewed Topics




© 2015