Filter spreadsheet too show only certain data

Question

I receive a daily reportwith over a thousand rows. I need to filter out to show only the rows I am responsible for.  Column A is what I need to filter off of. The data is in a 3 digit format, i.e.; 054, 107, 117, etc.. The data can also be reported more than once, 117 could show up on the report 5 times depending upon the errors received.

Answer 1

Lexie06,

Select all your data and go to sort & filter section on the right of the home tab of the ribbon.

click the dropdown and select filter. 

this will put dropdowns in the top row of your data.  In column A, click on the dropdown and choose the multiple selection check box.  then either unselect everything and select only those things you want or unselect those things you don't want (whichever is less work).

--

Regards,

Tom Ogilvy

Answer 2

Thanks Tom,

That would work, but on somedays I might have 500 or entries. I should have explained my post a little more than I did. What I would like to do is copy the incoming report into an excisting spreadsheet that would then filter out everything but what I am looking for. My columns would be building #, day, time, alarm. Sorry for not explaining in more detail to begin with.