Forum Discussion

scrail2004's avatar
scrail2004
Brass Contributor
Sep 30, 2024

Filters as Worksheet Title

I have an Excel worksheet that is an inventory list 17 columns wide.  I have Filtered the column headers (row eight) and I filter by various columns to generate different lists (I tried it with slice...
Excel on Mac
scrail2004's avatar
scrail2004
Brass Contributor
Oct 01, 2024
Sorry, this is my first post. I couldn't find how to add an attachment. How do I do that?
mathetes's avatar
mathetes
Gold Contributor
Oct 01, 2024

scrail2004 

 

After you start to reply, click on "Open full text editor"...down toward the bottom of the section that is then presented you see a place where you can drag and drop a file. If that doesn't work for you, use OneDrive or GoogleDrive and paste a link here.

 

  • scrail2004's avatar
    scrail2004
    Brass Contributor
    Oct 02, 2024

    mathetes Oh, full text editor is pretty slick.  But there is no window into which I can drop a file.  And I've never used OneDrive or GoogleDrive before.  The best I could figure out is to make the worksheet a jpeg file and paste it here (super-simplified version).  It's an inventory of teas.

     

    So if I filter the column headers and filter Type to show only Black teas, I'd like the title to read "Black".  Or if I filter Source to show only Mei Leaf teas, I'd like the title to read "Mei Leaf".  Or if I filter both of those, I'd like the title to read "Mei Leaf Black".

    • mathetes's avatar
      mathetes
      Gold Contributor
      Oct 02, 2024

      scrail2004 

       

      A jpeg which is small and low res, at least to my octogenarian eyes.

       

      Anyway, how are you filtering? Might I suggest that you use the FILTER function rather that the tool bar based filter. That way you could enter the word "Black" in a cell, a cell that is formatted to serve as a header, and use that same cell as the criterion in your FILTER function. The formula would look something like this, assuming the criterion "Black" is in cell A1; and column E is where the Type appears.

      =FILTER(database,E15:E100=A1)

       

      To make it more complicated and add the "source" as a second criterion, with"Mei Leaf" entered into cell B1

      =FILTER(database,(E15:E100=A1)*(F15:F100=B1))

       

      I don't know why you aren't seeing an area to drag and drop your file. I've got the full edit window open now, and I'm getting a screen grab of this sentence and what's below it

       

        

      • scrail2004's avatar
        scrail2004
        Brass Contributor
        Oct 02, 2024

        mathetes Thanks for the quick reply.  Yes, I know the jpeg was not ideal.  My eyes are sexagenarian, so I get it!

         

        When I first came up with this issue, I did exactly what you suggest.  I created worksheets (tabs) for all the ways that I typically filter my data and using the Filter formula, created all the lists I need.  I just hide the columns that are in my data worksheet, but I didn't want in the "printouts".  And it was easy, obviously, to put what ever header I wanted on each worksheet.

         

        I was just hoping there was a way to avoid adding all those worksheets.

         

        BTW, I can now see the drag and drop box!  I'll drop the file in, just to test it.