I figured the filter tool would be straight forward, but for some reason when I use a column that has X's, O's, and blanks, it recognizes that the info should be filtered out, but it is only filtering out the top row of the multiple rows that the filter column is covering. How do you get a filter to filter out an entire block of rows that it covers?
Can u give us more specific details about your problem? A sample workbook (with insensitive data) explaining your problem would also be of great help.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
I'll embed a PNG of a sample of the large table I am working with. The blacked out portions have sensitive data. I am trying to use the O column to filter out multiple rows that it spans across. The picture should clear up any questions.
ExampleFilteredExcelForForum.PNG
Anybody have any ideas? Filtering out multiple rows based on one column?
It's currently only filtering out the upper most row, and I would much rather not merge the hundreds of columns in the sheet manually.
Can you post a sample workbook (with insensitive data) instead of images?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks