Obtain Max./Min. Data from Multiple Sets of Data in Columns

[KGH]

I have data that is in columns A, B, & C. Column A is the counter for the sets of data, and may have anywhere from about 40 to perhaps 230 of the same integer in following rows. After this will come a new counter, not necessarily the following integer but always a greater integer. There will be many thousands of rows of data. I am looking for a way to place in columns F thru J the following respective data for each individual counter number, starting in cell F11. F would have the counter number, G would be the max. from column B, H would be the min from column B, I would be the max from column C, and J would be the min from column C. I would like the data for the first counter number in cells F11 thru J11, the second counter number in cells F12 thru J12, etc. There would also be in the rows of data some occasional random text, which could be discarded in the analysis.
Thanks for any help that could be offered.

 

[tusharm]

Re: Obtain Max./Min. Data from Multiple Sets of Data in Colu

The easiest way to do this is with a PivotTable (Data | PivotTable and PivotChart Report...). Make column A the row field. Duplicate each of B and C twice as the data fields. Set one instance to show the max., the other instance to show the min.