Dynamic Range -start with specific cell content

  • I'm looking for a dynamic range that start with specific cell content
    so the equation in the Refer to box appear like =OFFSET(A&match("flower*",$A:$A,0),......)


    flower* is a text in a particular cell of column A

  • Re: Dynamic Range -start with specific cell content


    Are you able to attach a sample workbook so that we can see what you are trying to do?

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules