Hi Claus,

Here in this workbook I have a very small sample.

On sheet 1 the yellow is where two LARGE values are in the same consecutive column so will return duplicate headers as seen on sheet 2. The lite blue is the second LARGE to avoid the dupe header.

The results on sheet 2 column A & B are what my little formula code does, which produces the format correctly but you can see it duplicates Header1.

The correct result is shown in column E & F as an example..

If there are only five rows, then it should only show five rows, although there will probably be 300 rows all the time.

Hope this helps, because I know you can do the code if I can just get my act together and explain it properly. Sorry for the sloppy info stream.

Howard


https://www.dropbox.com/s/bcpva2gjju...lumn.xlsm?dl=0