I have a spreadsheet that contains multiple columns with prices (I have defined the range as "Sale_Prices"). I can determine the lowest price in the Sale_Prices range using the MIN function. I now want to find the highest price in the spreadsheet that is no more than $0.99 higher than the lowest price (essentially, I will need to group the prices into $1 ranges). Any help in writing that formula would be appreciated. I would prefer to avoid array formulas if possible.
A sample spreadsheet is attached. The data is in the "Raw Data" tab and the formula should go in cell B4 of the "Calcs" tab. Thanks!











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks