+ Reply to Thread
Results 1 to 3 of 3

Isolating & Returning Data

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    30

    Isolating & Returning Data

    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.

  2. #2
    Registered User
    Join Date
    01-12-2011
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Isolating & Returning Data

    Looks like I cant upload the excel file at the moment. I'll try again in a few

  3. #3
    Registered User
    Join Date
    01-12-2011
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Isolating & Returning Data

    The file is now attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1