Sorry - first post ever. Here is what I'm trying to do:
Spreadsheet Structure:
Column A Column B Column C
111111 12345 0.25
111111 23456 0.33
111111 34567 0.21
222222 23564 0.11
333333 34564 0.37
333333 23546 0.44
444444 12345 0.71
Requirement:
Don't care if this uses functions or VBA. I need something to go through the spreadsheet, and for each unique value in column A, return the MIN value in column C and the associated value for column B into a new worksheet along with the value from Column A. So in the structure above, the output of the code would be, in a new worksheet:
Column A Column B Column C
111111 34567 0.21
222222 23564 0.11
333333 34564 0.37
444444 12345 0.71
One more observation - the actual data set is much larger - several thousand rows. There could be anywhere from one to 100 similar values in column A. Not sure this matters but thought I would mention.
Any ideas would be greatly appreciated.
Bookmarks