Select data from a worksheet with specific text

  • Hi All,


    Is there a formula that would populate a range from a worksheet that meets specific criteria.


    i.e.Worksheet "Orders" Column (B) holds my data, but I only need to show data from specific cells/rows that start with "Supplier"


    So, if any cell in column (B) starts with "Supplier", return the whole string of that cell into my table S5:S100 on Worksheet "Summary" i.e. "Supplier - Alpha Beta Marketing"


    Thanks

  • Hi Roy,


    My data is on different worksheets and I need to populate a range with data extracted from the Orders worksheet?
    Data changes on the orders sheet each day, and I would like the range which populates a chart change automatically.


    I cannot see how using filters will accomplish this?


    Thanks

  • Hello,


    Would suggest to attach ... guess what .. a sample file ...:wink:


    This would allow ... yes ... to visualize ... both the input AND your expected result ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim
    Looks great, but when I add more suppliers, the list starting at Cell B7 is not updated?


    Thanks


    Hello again,


    With more Suppliers beyond row 17 in your worksheet Orders ...


    would require that within the formula ... you just replace the number 17 ... by whatever higher number you need ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim


    I tried increasing the number from 17 to 100 but it did nothing, in fact, it did not return anything?
    Then I realised that the function was an Array.


    Fixed now


    Thanks


  • Indeed ... it is an Array Formula ...:wink:


    Is it now working fine ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • It is on your worksheet after I enter using Ctrl/Shift, but on my worksheet, I am prompted to open a sheet !
    I assume this is because my worksheet now has a space in the tab name.



    Otherwise it works great.


    Thanks


  • You are right ...


    Glad you have also managed to solve this issue ...:wink:


    Thanks again for your Thanks ... and for your reputation point ... with the Like icon ... :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!