How to skip lines of data without leaving a gap in format

[tkoral]

Hello!

I'm not quite sure how to summarize what I'm looking for, otherwise I think my EXTENSIVE Google searches would have been more effective :P

I've attached a data sample showing an example of a data set I have and the desired finished product. In essence, what I'm looking to do is create a way, preferably just using a formula, to identify "Accounts" that are less than 5 and exclude them from the Final Product. The other hairy part of the equation is, I would like to accomplish this by keeping my "Areas" in sequential order. What I tried to do was just sort the "Accounts" largest to smallest and write a formula to exclude "Accounts" below 5, but my "Areas" fall out of order. Alternatively, if I keep the "Accounts" in the same order and write the same formula, I end up with gaps, or simply blank lines interlaced throughout my "Final Product".

Hopefully my example will provide some additional clarity. If you have any questions at all, please let me know. Thank you in advance for your time in trying to figure this one out. I really appreciate it!

Tyler

[AliGW]

In H4:

=IFERROR(INDEX(B:B,SMALL(IF($D$4:$D$8>4,ROW(B$4:B$8)),ROWS($A$1:$A1))),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Once entered, drag copy across and down.

[tkoral]

In H4:

=IFERROR(INDEX(B:B,SMALL(IF($D$4:$D$8>4,ROW(B$4:B$8)),ROWS($A$1:$A1))),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Once entered, drag copy across and down.

AliGW,

You are a genius! Thank you so much for hopping on this. For the record, this is NOT the first problem you've helped me solve, so thank you x 1,000,000!!

[AliGW]

You're welcome (again)!!!

Thanks also for the rep and very nice comment.