1 min readfrom 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:

https://imgur.com/a/d0jNtNx

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:

https://imgur.com/a/pgVJsLm

And not like this:

https://imgur.com/a/wCev8uH

Perhaps the filter function isn't the right approach, so I am open to alternatives.

submitted by /u/drspudbear
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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