•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filtering rows by cell value
Our take
To filter rows by cell value in Excel and streamline your invoice table, you can utilize the built-in filtering functions. Begin by applying a filter to your data range, specifically targeting the "Category" column to exclude any line items marked as "Labor." After filtering, you can use the "Group" feature to collapse rows with the same invoice number, ensuring only relevant items are displayed. This approach not only simplifies your view but also enhances productivity by focusing on the data that matters most to you.
New to Excel but trying to put this together for work. I’m trying make a table where each row is an invoice line item, but I need to remove/hide any items on invoices containing labor. Column 1 is Category with Labor, Parts, etc. and tab 4 is invoice number. I want to single out line items with labor in tab 1 and collapse all lines with the same invoice number so it only shows items from invoices without labor. Is there a function or chain of functions that could do that?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience