+ Reply to Thread
Results 1 to 7 of 7

Display items in order without BLANKS

  1. #1
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Display items in order without BLANKS

    Hello friends, Hope all is well!

    I need your kind help please. Ignore all the sheet, and let us only focus on L & Q.
    L cells change, sometimes are either blank, or have a month name.
    I want the Q range to show the values INORDER from the L range (without BLANK).

    your kind help is needed and appreciated, always!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,853

    Re: Display items in order without BLANKS

    Maybe :
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Re: Display items in order without BLANKS

    great! thanks, but cant it be done with a formula instead?

  4. #4
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,236

    Re: Display items in order without BLANKS

    Sir karedog its array i like it

  5. #5
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,853

    Re: Display items in order without BLANKS

    @countryfan_nt :
    You are welcome.
    Array formula on cell Q8 :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    @daboho :
    Thank you sir
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Re: Display items in order without BLANKS

    A true Guru! Terima kasih

  7. #7
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,853

    Re: Display items in order without BLANKS

    Sama-sama, terima kasih

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to keep items in ListBox in alphabetical order when removing and adding items to box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-31-2015, 07:13 AM
  2. Values associated with listbox items when blanks are skipped
    By Koshimura in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 05:12 PM
  3. Pivot Table descending sort order of (Blanks) + VBA
    By bezwlosy in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-09-2014, 07:38 AM
  4. [SOLVED] Place two staff on each day in order, skipping blanks
    By RonNCmale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2014, 07:57 AM
  5. Replies: 2
    Last Post: 11-03-2012, 02:53 PM
  6. Sort order with Blanks
    By DanBlum in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2011, 12:02 PM
  7. [SOLVED] order form with multiple items and sizes for items
    By Bernard56 in forum Excel General
    Replies: 1
    Last Post: 01-17-2006, 07:50 PM

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