Numbers More Than a Specific number

[soleimani1967]

On column "A", I have many numbers from A2:A25. I want to have the numbers of column "A" which are more than a specific number on column "B".
Is there any function or formula in excel to enter on cell B2 and copy on B25 for solving this problem?
For example, please see attached file that a specific number is "21". I need to collect all numbers on column "A" which are more than "21" on column "B".

[63falcondude]

I assume you're looking for one of these:

B2 =IFERROR(INDEX(A:A,SMALL(IF(A$2:A$25>21,ROW(A$2:A$25)),ROWS($1:1))),"") Ctrl Shift Enter

or

B2 =A2>21

[soleimani1967]

Thanks. Your formula as well as work.

[63falcondude]

Happy to help. Thanks for the rep!

[soleimani1967]

Hi everybody,

How can I change the title of a post? My title is wrong now. I should change "Then" to "Than"

[63falcondude]

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[soleimani1967]

Thanks a lot again.