213735/calculate-monthly-highest-selling-product-ms-excel
Using Excel, I'm attempting to determine which product has the most monthly sales. Excel is new to me, thus I've had trouble figuring out what formula to use.
Use a Pivot Table to summarize the data. Use these columns in your fields:
Click the dropdown arrow in the Product column, choose value filters, and Top 10. Choose the top 1 by the sum of sales:
Using MS Excel (2010), I would like ...READ MORE
Hello, to open xlxs files, or files ...READ MORE
1 I have 4 arrays of data where ...READ MORE
Write =Today-C3 and then press Ctrl+1 and select Number for the format. Or try ...READ MORE