Not sure I understand the data, can you post a sample workbook and tell us expected results?