Filter by merged cells dilemma

  • Hello -

    I've attached workbook Filter by Merged Cells. Raw Data (tab) contains simple table, with column A containing merged cells. Expectation Mockup tab details outcome I am trying to build towards.

    Problem: Use Filter tool in Excel to return all items in columns B to C, for item selected in A (column A contains merged cells).

    Is there an easy way to achieve this? Since I cannot utilize Center Across Selection vertically, how can I return all items in column B to C, for single item in merged cell A?



  • Hello @Logit & @Carim - Thank you for your responses, both methodologies work and have their pros and cons. I appreciate you sharing your information and expertise. This issue can be considered closed.

  • Glad you could fix your problem

    Thanks for your Thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" 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!