Hi there,
I have data in the attached workbook. You will see in column A there are rows of 1's, 2's .....80. In column B there are decimal numbers.
https://dl.dropbox.com/u/54057365/All/min%20max.xlsx
In column C I'm looking to return the min and max of the data in Column B. I'm seeking help with a macro to do this as I have to do this many times and it is very time consuming not to mention boring.
I have done an example for the rows of 1's and 2's. You can see the min and max data in column C.
Appreciate you help and time
J