Need a formula

[ahmad08]

Hi Excel Experts,

I have list of 50,000 people, they have different amount of money in their account.

There is a required amount of money which always vary.

I want a formula by which I will enter only required amount and can find the person who has equal or more amount than required amount.

Below is link of my Excel Sheet.

Who has more or equal amount than required.xlsx - Google Drive

Thanks in Advance for your kind support.

 

[mole999]

apply a filter to your list, then use the filter to select

 

[Aladin Akyurek]

Let A:B house people and money they have.

Let D1 house a required amount.

In D2 just enter:

=COUNTIFS(B2:B1000,">="&D2)

In D3 control+shift+enter, not just enter, and copy down:

=IF(ROWS(D$3:D3)>D$2,"",INDEX($A$2:$A$1000,SMALL(IF($B$2:$B$1000>=D$1,ROW($A$2:$A$1000)-ROW($A$2)+1),ROWS(D$3:D3))))