•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Assistance with advanced filter options
I have a report that is being generated through some janky software, and unfortunately the way I am getting the excel document can't be changed. This is a very basic example of what the sheet looks like, the actual generated report is thousands of rows:
For example, I want to filter for Bob's name in column A and also see all of Bob's associated comments in column B. If I apply a filter for Bob in column A, it hides everything in column B that are the relevant comments (obviously).
To clarify, I want a filter to make it look like this:
And not like this:
Perhaps the filter function isn't the right approach, so I am open to alternatives.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel alternatives
#Excel compatibility
#digital transformation in spreadsheet software
#financial modeling with spreadsheets