It would be very helpful for all concerned if you posted a sample spreadsheet showing your data (and possibly what the desired result would look like). Please see this link to the FAQ for instructions on how to post an attachment.

Cheers,