Hi
I'm trying to get the attached workbook to take user input in three sections and display a result based on the user input. Using the filter option, I can isolate the data returned based on the input in B2 & C2, however I havent been able to get the filter to work on the input in E2, which needs to combine the info in cells D3-K3.
Is there a way to have the filter option appear in one cell while filtering data from multiple cells?
I was also wondering if its possible to format cell E2 so that if a user inputs any number (Say 425) that it will select the next highest value (500)? Can that be done through conditional formatting?
Thanks for any help I can get.
Bookmarks