+ Reply to Thread
Results 1 to 4 of 4

Get values on top, skip blanks, OFFSET?

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Get values on top, skip blanks, OFFSET?

    So I want all the values that have a value to be on top of the yellow cells, and the blank cells below.. so 'Mobiele kosten' and 'Zorgverzekering in B35 and B36 should be in B24 and B25, and the blank cells below that.. I think its possible with OFFSET?fw.xlsx

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Get values on top, skip blanks, OFFSET?

    If I have interpreted correctly copy, paste and enter this array formula in cell B24.

    Array formulas are not committed in the regular way. You commit by pressing and holding Ctrl + Shift as you hit Enter. You will know that it has been entered successfully when you can see curly braces {} around your formula in the formula bar. You do not type these in yourself. Excel does it for you.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then fill down to B36.
    Last edited by FlameRetired; 02-25-2015 at 06:56 PM.

  3. #3
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Get values on top, skip blanks, OFFSET?

    It works! Awesome thanks +rep for u

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Get values on top, skip blanks, OFFSET?

    Great! Thanks for the feedback and the rep!

+ 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. Skip Blanks
    By juanp21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 03:06 PM
  2. Offset Function To Skip Blanks/Zeros and Corresponding Header When Charting
    By caveatemptor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-11-2012, 03:42 PM
  3. Skip Blanks
    By Streng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2009, 04:12 PM
  4. skip blanks
    By Robin Krupp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2006, 08:50 AM
  5. [SOLVED] Paste Special Skip Blanks not skipping blanks, but overwriting...
    By gsrosin in forum Excel General
    Replies: 0
    Last Post: 02-22-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1