Hi Burnrose and welcome to the forum,

If you attach a sample workbook with your picture data above and tell us what the final answer is supposed to be, I'm sure we can twiddle up an answer. Read the yellow banner at the top to see how to attach a workbook.