Here is what I am trying to do. I have some land that I want to build 6 rental properties on it that will maximize my rental income. I have 5 different homes I can choose from and each have different rental amounts. I could choose the home that would give the most rent and build 6 of those...
Here is what I am trying to do. I have placed the values in column A into ranges like 0-1099, 1100-1499, 1500-1999, etc. So the question is how do I find the max price of the range 3000-3500. The answer should be 249900.
A B
1 SQFT Price
2 3242 242000
3 2100 146500
4 2664 465900
5 3395...