Results 1 to 3 of 3

Array formula to remove blanks (like autofilter)

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003, 2010
    Posts
    17

    Array formula to remove blanks (like autofilter)

    Hey everyone,

    I've been trying to figure out what I believe is a simple problem but I can't get it right. Attached is a sample spreadsheet that will hopefully illustrate my goal more clearly.

    I have several customers that order various items. However, they do not all order the same things nor do they all receive the same prices due to volume, etc. So what I'm trying to do is that when I select the customer in cell J3, that columns I and J fill with the non-blanks from the table in B4:E19. My assumption is that the items will have to be referenced from the costs but I'm not totally sure about that since there would are non-unique prices.

    This is essentially an auto-filter problem without using the built-in function but I swear I've had something like this set up before. Thanks for any help.
    Attached Files Attached Files
    Last edited by CST; 02-13-2012 at 12:53 PM.

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