subheading

  1. M

    FILTER Function - Maintaining subheadings without #SPILL

    Hi, To begin with, I'm stuck using cell formulas due to Excel Online.... & I would ideally like this to be recalculated when formulas are recalculated. I'm looking to format my data below like it is under "Ideal output" I would like to avoid spill errors if I find more ID matches, and push...
  2. B

    Dependent dropdownlist on Excel table with subheaders

    Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough. I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each...
    • BURTPRI
    • Thread
    • dropdown list row subheading subheader subheading table
    • Replies: 21
    • Forum: Excel Questions
  3. K

    Filter all but one middle row

    I have a list which I would like to be able to filter while leaving one merged row/cell in the center always visible. Is this possible? Essentially I have a data set sorted by date. I have reports of an issue prior to a corporate communication going out and then after. I would like to be...
  4. M

    Custom function to find Heading & Subheading

    Hello everybody, I am having a situation where I have heading of certain names or items and it is spread across 3-5 cells (merged as one) and underneath these cells there is subheading (each item occupying single independent cell). I just want a custom function that can LOOKUP the heading and...
    • Meesam
    • Thread
    • advanced_lookup heading index lookup subheading
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top