Hi,

I have a column of numbers of items sold, and an adjacent column with days of the week (for 2 months)

Is there a formula to correlate these to find out e.g. if sundays are the worst days of the week for selling items


Similarly I have another adjacent column of dates (which i used to find the days of the week). Can I correlate months with items sold. i.e. what month is the best or worst for selling the items.



Cheers