Results 1 to 3 of 3

return only available data

Threaded View

  1. 10-20-2015, 04:23 AM #1
    Queenie Balb
    Queenie Balb is offline
    Registered User
    Join Date
    10-13-2015
    Location
    Auckland
    MS-Off Ver
    2013
    Posts
    12

    return only available data

    Hi guys,
    I have detected an unforeseen problem. Please open the file MOCK UP JOURNEY PLAN and look at the cells colored in yellow.

    In tab Journey Plan, I need to return the top 5 products in range H19:L23.
    This info is in tab Categ, range Q:U.
    The formula works alright, but when I come to Polynesian spa, it only has 3 products. These 3 products are returned into tab Journey Plan range H19, H20 and H21. However, on H22 and H23, the formula picks up the products from the following Spa (Champs Elisees).
    I need the range H22:H23 to show blank.
    Anyway, I thought this would easy to fix because these fields are driven by cell B1, but I am having trouble with this.
    Can you please help? The file is attached.
    Thanks a lot.
    Attached Files Attached Files
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find data based off unique identifiers and return only columns showing data
    By yomamma34 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-23-2014, 05:03 PM
  2. Double click row to return data to userform for edit then return back to sheet
    By MattRSJ in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-31-2014, 06:05 AM
  3. [SOLVED] SUMIF - If there is no value to return, return "NO DATA TO DISPLAY"
    By Ben1985 in forum Excel General
    Replies: 3
    Last Post: 12-01-2013, 05:40 PM
  4. [SOLVED] Data Validation --> Return Multiple Values via VLookup from Dynamic Data
    By No_Guru in forum Excel General
    Replies: 9
    Last Post: 11-26-2012, 12:46 AM
  5. Excel 2007 : Search data. If found, return data and color original cell background
    By tjbvo in forum Excel General
    Replies: 0
    Last Post: 01-14-2012, 02:13 AM
  6. Changing VBA code to return data range, appending to prior data
    By camcrazy08 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2007, 10:53 AM
  7. Index Row and return data in a Single Column:No return
    By Domenic in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1