Extracting the top 10 maximum values

1. Extracting the top 10 maximum values

attempted a formula to bring back the top ten most repeating values that match a criteria. So far I'm using...

Formula:
`Please Login or Register  to view this content.`

to get the top ten reoccurring numbers, then in the next column using

Formula:
`Please Login or Register  to view this content.`

to show the number of times the number occurs in the range. How would I show how many times the number occurs in the range for just one criteria ignoring any blank cells in the range? I've attach an example.

Attachment 614490

2. Re: Extracting the top 10 maximum values

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

3. Re: Extracting the top 10 maximum values

Thank you, I have attached a new file for review.

4. Re: Extracting the top 10 maximum values

Try Entering this Formula in F2

=SUM(IF(\$A\$2:\$A\$117&\$B\$2:\$B\$117=E2&C2,1,0))

Enter using Ctrl Shift Enter

5. Re: Extracting the top 10 maximum values

Interpreted a little differently. Your original array formula modified in F2
Formula:
`Please Login or Register  to view this content.`
Then in G2
Formula:
`Please Login or Register  to view this content.`

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1