Find Max and Min Values every 10 rows & Mark row as keep

[Jmino]

Hi,

I need help creating a formula in excel to Identify the two Rows with the Highest and Lowest values in Column B EVERY 10 rows. THEN Identify those two rows by placing some text or number in Column C in only the rows with the highest and lowest values. For example I want to return the word "keep" in Column A3 for ONLY the Highest and Lowest trade price for each 10 row incement. This way I can sort the data by "Keep" and delete the other 8 rows of data. I can keep my data integrity and greatly reduce the size of the files.

I am using Excel 2007 and I have a 160,000 rows of data. The purpose of the formula is to cut this data down to by 80%

The spreadsheet below gives a simple example of what I need to do.

Any help would be greatly appreciated.

Thank you,
Joe

[mdbct]

In C1 and copy down.

Please Login or Register  to view this content.

[Jmino]

Thank you mdbct.

This formula is perfect.

I really appreciate your help.