Closed Thread
Results 1 to 6 of 6

INDEX formula to only pull visible cells

  1. 05-18-2018, 11:46 AM #1
    chrislid33
    chrislid33 is offline
    Registered User
    Join Date
    12-31-2014
    Location
    orlando, florida
    MS-Off Ver
    7
    Posts
    5

    INDEX formula to only pull visible cells

    I would like to pull only the visible cells in my index formula. See below and attachment (having trouble attaching on the post so will attempt to post the file soon) for details.

    I would like cells B10, D10 and F10 to only pull data from visible cells. I already have the successful INDEX formula in there and just need help using the SUBTOTAL function within this formula.

    So for instance B10 right now is showing Project #1 but should really be showing Project #5 as shown on the Initiatives Status tab.

    Note: The filtered column is column O.

    Thank you.
    Reply With QuoteRegister To Reply
  2. 05-18-2018, 11:49 AM #2
    chrislid33
    chrislid33 is offline
    Registered User
    Join Date
    12-31-2014
    Location
    orlando, florida
    MS-Off Ver
    7
    Posts
    5

    Re: INDEX formula to only pull visible cells

    I'm still having trouble uploading the file. How do I do this? When I click on the paper clip a small white horizontal box pops up with nothing in it...
    Reply With QuoteRegister To Reply
  3. 05-18-2018, 11:51 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: INDEX formula to only pull visible cells

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 05-18-2018, 11:57 AM #4
    chrislid33
    chrislid33 is offline
    Registered User
    Join Date
    12-31-2014
    Location
    orlando, florida
    MS-Off Ver
    7
    Posts
    5

    Re: INDEX formula to only pull visible cells

    Yes that worked. Thank you. I have attached the file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-18-2018, 04:06 PM #5
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: INDEX formula to only pull visible cells

    @Ford,

    The OP has the same question posted in the commercial services forum with an answer already provided.

    Not sure if this should be closed and the points awarded in the commercial services.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  6. 05-18-2018, 07:01 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: INDEX formula to only pull visible cells

    Thanks Jeff, did not know that, I will close this 1 so the CS thread can continue.
    Reply With QuoteRegister To Reply
Closed Thread
« 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. Index only visible cells
    By profecientiamnot in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-19-2021, 07:28 AM
  2. Index and Match Function wont pull cells hyperlinks
    By gum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2019, 12:02 PM
  3. Small/Index to Pull Specific Instances and Leave out cells unpopulated.
    By donnieboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2015, 06:08 AM
  4. Using the INDEX and MATCH Formula to pull costs.
    By AntP_ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2014, 08:09 AM
  5. [SOLVED] using Index, Match, Large, and Visible Cells in one formula
    By jomili in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2013, 01:58 AM
  6. [SOLVED] Array Formula using Index, Small, If and Visible Cells in One Formula (Autofilter)
    By holmstarrunner in forum Excel General
    Replies: 2
    Last Post: 06-20-2012, 12:22 PM
  7. Using the INDEX formula to pull non-zero values.
    By tavlrb in forum Excel General
    Replies: 5
    Last Post: 02-17-2011, 03:48 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