I'm creating a spreadsheet that will take about 500 different medical plans and sort them based on how close they are to a clients current plan. I'm looking at about 6 columns with information in them that I would sort on. Two examples of the data colums would be deductible and doctor visit copay.
Example: companies current plan has a $1,500 deductible and a $20 doc visit copay. I put those two values in and the 500 plans are sorted based on the deductible and then the doc copay. Here's the kicker I need help with. The company may say we want the deductible to be $1,500 or less or they might say it can be a little more. But in the end I need to sort the plans that are the closest match (above and below) to their variables.
Bookmarks