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.

Nov 12, 2022 in Others 1,470 views

## 1 answer to this question.

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:

• 63,700 points

## MS EXCEL: Convert (Height) Decimal Feet & Inches to Inches Only

Using MS Excel (2010), I would like ...READ MORE

## How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## Calculate age in excel

Write =Today-C3 and then press Ctrl+1 and select Number for the format.  Or try ...READ MORE

## Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF(\$M\$2:\$M\$5;A2) If the product is present in ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE