Consulting

Results 1 to 5 of 5

Thread: Display succeeding column data while skipping blank cells

  1. #1
    VBAX Newbie
    Joined
    Jul 2021
    Posts
    2
    Location

    Display succeeding column data while skipping blank cells

    Hi All,

    I would like to get your expert advise on how to get around this issue I am encountering.

    I am trying to populate a cells so that it will lookup the value from row while skipping blank cells within that row and displaying those values in a column.

    So whenever a lookup value is populated on C3, it will lookup DataSheet sheet from Column B to O and display the value on cell C6 to C8 skipping blank cells.

    Thank you! Appreciate anyone's assistance on this.
    Attached Files Attached Files

  2. #2
    VBAX Contributor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    199
    Location
    Which version of excel you are using?
    Do you have filter and unique functions ?

  3. #3
    VBAX Newbie
    Joined
    Jul 2021
    Posts
    2
    Location
    Quote Originally Posted by anish.ms View Post
    Which version of excel you are using?
    Do you have filter and unique functions ?
    I am using Excel Online, and no I do not have any filter or unique functions. The datasheet is where I dump the data I gather, I just want to be able to display the cells that are not blank regardless of how many columns there is. Hope that clarifies it?

  4. #4
    VBAX Contributor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    199
    Location
    If you have filter function in excel (2019 or 365 version), paste below formula in cell C6
    =TRANSPOSE(FILTER(FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3),FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3)<>"","No values found"))

  5. #5
    VBAX Contributor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    199
    Location
    This forum is for VBA codes and the codes wont work in excel online.
    You may have to check the possibility of Office Scripts in Excel on the web.
    Expecting experts in this forum to comment and help you in this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •