Forum Discussion

ltmurph's avatar
ltmurph
Copper Contributor
Apr 06, 2021
Solved

Making a simple report

I am a complete novice to Excel.  I have a data sheet with names of people, last name in col. A, first in Col B and whether or not (Y/N) they are members in col H. First I want to isolate the non mem...
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 06, 2021

    ltmurph 

    Let assume you have such data

    - select headers (click on A2, press Shift, click on H2, release Shift)

    - click on Filter icon in Data section of the ribbon

    On the right of each cell filter button will appear. Click on one in column H and deselect N

    Result is

    on ribbon File->Print->Print

     

Resources