Results 1 to 9 of 9

Picking entries left to right and skipping blanks

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    Picking entries left to right and skipping blanks

    In the example attached, I have formulas which pick the entries from the "red" columns, one by one left to right (skipping the blanks), and when there is no more entries, the formula goes back to the beginning and picks the entries in the same order again.

    For example:
    _ 1 _ 2 = 1212
    _ _ 1 _ = 1111
    1 _ 2 3 = 1231

    I need the same but with SIX columns. Can someone help me do that, using similar formulas or somehow "spreading" the idea to two more columns?

    For example:
    _ 1 _ 2 _ _ = 121212
    1_ _ _ 2 3 = 123123

    Thanks in advance
    Attached Files Attached Files
    Last edited by Hitch75; 10-13-2011 at 10:40 AM.

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