+ Reply to Thread
Results 1 to 4 of 4

Challenging formula for spaces in data

  1. #1
    Registered User
    Join Date
    06-16-2017
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    21

    Challenging formula for spaces in data

    Hello,

    I am trying to make a formula that will fill in rows with the Symbol listed directly under it. But once passed that symbol, I would like it to grab the symbol underneath that one. It is complex to describe. I have attached a file with more clarifications.

    Alex
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,039

    Re: Challenging formula for spaces in data

    Try this formula in H3 and fill down until you get blanks.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Challenging formula for spaces in data

    Is the goal to ultimately get column C correctly filled with the values?

    If so, try highlighiting column C and press CTRL + G
    Click Special
    Select Blanks
    Click OK (DO NOT PRESS ENTER)
    Press =
    Press DOWN Arrow Key
    Press CTRL + ENTER

  4. #4
    Registered User
    Join Date
    06-16-2017
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    21

    Re: Challenging formula for spaces in data

    You are a legend. This saves me big time. Thank you so much

+ 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. Excel formula - need assistance with challenging formula or table
    By m masi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-05-2017, 08:19 AM
  2. Very Challenging Multiple Cell Reference Formula
    By EverClever in forum Excel General
    Replies: 30
    Last Post: 12-20-2014, 11:26 AM
  3. [SOLVED] Challenging Formula Cumulative sum up to a number
    By crisaldana in forum Excel General
    Replies: 8
    Last Post: 06-17-2014, 10:42 AM
  4. Help with challenging array formula
    By chuji in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2013, 02:11 AM
  5. Need Help with a challenging formula.
    By gamiensrule in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2010, 10:05 PM
  6. Challenging Formula
    By Gordon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-23-2006, 04:30 PM
  7. Answers needed for challenging formula
    By Sum Limit and marking in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-17-2006, 07:20 AM

Tags for this Thread

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