Hi All,
Attached is a sample sheet to help my plight.
I hope sheet 2 explains enough for for you to help me.
The sample data is a small amount compared to the actual data, and I need the formula to be as dynamic as possible due to addition and deletion of data from sheet1
Thanks