•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
i want to filter and get the rows that has values in a specific column
Our take
To filter rows that contain values in a specific column, such as deposits for March, you can utilize a combination of filtering and data validation in your spreadsheet. Start by filtering the March column to exclude blanks, ensuring only relevant entries are displayed. To enhance usability, consider implementing data validation that allows you to select a month from a dropdown list, making your filtering process dynamic.
here i want to filter rows that will deposit in march for example, so any row that doesnt have blanks in the march column, i want them to be there, but i dont want all the data, i just want the client specific columns, like client name, date and amount of money, i know i can filter the the march column to not include blanks, but as i said i dont want all the columns and data, and its preferable that i can add a data validation to it so i have a list of the month to chose and filter with to make it more dynamic
output exmaple
[link] [comments]
Read on the original site
Open the publisher's page for the full experience