Hi,
I'm looking for some help in building a dynamic list from a range with multiple constraints without using the Excel standard filters (I'm trying to improve my hockey pool performance by drafting faster and more efficiently!). So basically, I have a list of 800+ players with different statistics for each player like expected points, salaries, position, whether they were already picked by another person, etc.
Let's say the columns in my initial range are the following:
Player name: Column B
Position: Column C
Expected Points: Column D
Salary: Column E
Whether they were picked: Column F
I would like to have a few fields where I manually input whether I'm looking for a Defenseman (field 1) that costs less than 5M$ per year (field 2) and that is expected to make more than 60 pts (field 3) and that hasn't been picked by another person in the pool yet (field 4; set by a simple 1 for taken, 0 for available). Once I have input all these parameters for the search, I would like to have a list of the top 25 players that fit those criterias sorted by Expected points (field 3).
I figured that I'd need to use an index function and possibly the small function but I would need help to structure it all and have proper syntax for the formula. Could you help me build it out please?
Thanks, any help will be extremely appreciated!
I'm looking for some help in building a dynamic list from a range with multiple constraints without using the Excel standard filters (I'm trying to improve my hockey pool performance by drafting faster and more efficiently!). So basically, I have a list of 800+ players with different statistics for each player like expected points, salaries, position, whether they were already picked by another person, etc.
Let's say the columns in my initial range are the following:
Player name: Column B
Position: Column C
Expected Points: Column D
Salary: Column E
Whether they were picked: Column F
I would like to have a few fields where I manually input whether I'm looking for a Defenseman (field 1) that costs less than 5M$ per year (field 2) and that is expected to make more than 60 pts (field 3) and that hasn't been picked by another person in the pool yet (field 4; set by a simple 1 for taken, 0 for available). Once I have input all these parameters for the search, I would like to have a list of the top 25 players that fit those criterias sorted by Expected points (field 3).
I figured that I'd need to use an index function and possibly the small function but I would need help to structure it all and have proper syntax for the formula. Could you help me build it out please?
Thanks, any help will be extremely appreciated!
