consolidating data points of interest

    I have a long list of data points in a single column with certain points of interest identified by a "1" in adjacent cell (helper column). I am trying to make another shorter column that displays only the data points of interest. Anyone know of a good way to accomplish this?

    Re: consolidating data points of interest


    If I do that it filters the entire spreadsheet though which I do not want. I am trying to get only the Data and helper column to be affected as there are other data/helper columns that I want to filter seperately. essentially I need to apply a dynamic filter to individual columns

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login