Top N results -BUT- with criteria (omit blanks and 'none')

D

dmj120

Active Member
Joined
Jan 5, 2010
Messages
310
Office Version
  1. 365
  2. 2019
  3. 2010
I have the below which works ok, but I need to to exclude blanks and "none" in Col 19.

Code: 
=INDEX(SORT(flatFile!$A$6:$V$377,19,-1),SEQUENCE(overview!$A$2),{3,4,6,17,19})
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Maybe
Excel Formula: 
=INDEX(SORT(filter(flatFile!$A$6:$V$377,(flatFile!$s$6:$s$377<>"")*(flatFile!$s$6:$s$377<>"none")),19,-1),SEQUENCE(overview!$A$2),{3,4,6,17,19})
 
Upvote 1
Solution
Fluff said:
Maybe
Excel Formula: 
=INDEX(SORT(filter(flatFile!$A$6:$V$377,(flatFile!$s$6:$s$377<>"")*(flatFile!$s$6:$s$377<>"none")),19,-1),SEQUENCE(overview!$A$2),{3,4,6,17,19})
Click to expand...

Awesome, thanks!!!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Solved
Copying ranges while eliminating blanks yields unexpected results
Replies
3
Views
87
Alex Blakenburg
A
C
  • Question Question
Showing highest selling product based on criteria
Replies
3
Views
452
Fluff
Fluff
Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
415
Asbestos_Jen
Asbestos_Jen
H
  • Solved
Return and rank top 3 results (including ties) from VSTACK, FILTER, CHOOSECOLS, and SORT formula
Replies
8
Views
317
Peter_SSs
Peter_SSs
P
  • Solved
Lambda and custom sequence with interference of string
Replies
3
Views
294
StephenCrump
S

Forum statistics

Threads
1,225,477
Messages
6,185,210
Members
453,283
Latest member
Shortm88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top