There are no formulae in the workbook you have posted and it bears no relation to the data you have in your posts above. The reason I asked for a workbook is because it makes it easier for those trying to help you: otherwise they have to recreate the data for themselves and, inevitably then, there are mistakes made. Much easier all round to see the data in situ in an Excel file. Could you please post a file that actually relates to your query?