On Jun 12, 9:56*pm, "Maxx" wrote:
In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order the
same quantity I ordered last time. If they are declining I will order fewer
than *I ordered last time.

Can Excel help here?

while pivot table/etc would work at finding your Top10 sellers, it
sounds like that is merely the first step and suggest plotting the
daily sales for those titles over a period time (say since the last
order was placed) for a graphical view of the data to see what trend
(s) emerge.