Get a list of people who are less than 150 or taller than 185

Hi everyone , how i can In Excell sort In cell E1, get a list of people who are less than 150 or taller than 185





Max 200 Answer: $here
Yulia 149
Leo 180
Andre 187
Mark 148

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Try this:

=FILTER($A$2:$A$5,($B$2:$B$5<150)+($B$2:$B$5>185))

Well, you have told us in your profile that you have Office 365 - this will need changing, please. What version do you have???

In E1 drag copied down:

=IFERROR(INDEX(A$1:A$500,AGGREGATE(15,6,ROW($2:$500)/(($B$2:$B$500>185)+($B$2:$B$500<150)),ROW(1:1))),"")

And did you drag copy down, as I told you???

No, you haven't drag copied the formula down - there is no formula in E2 or E3.

Once you have copied down you will see this:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E
1	Max	200		Answer:	Yulia
2	Yulia	149			Andre
3	Leo	180			Mark
4	Andre	187
5	Mark	148

Sheet: Page1

See the example I attached to my previous post.

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Drag copy ACROSS and then down (or down and then ACROSS). See K1.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.