horsechamp
New Member
- Joined
- Jan 6, 2014
- Messages
- 2
I had a group of data columns and I needed to determine the difference between the maximum and minimum values for each column. Since I have never written a macro in excel, I manually individually sorted the values in each column to put the highest value in the first row and the lowest value in the last row and then I entered a cell formula to subtract the last row value from the first row value for each column. This worked but there must be an easier and more elegant way to do this using a macro. What is a better way to do this?