I have to organize thousands of rows for work and I want to hide all rows that have a 1 in column H but a 0 in column F. Obviously I can scroll through thousands of rows and hide them by myself but is there a way that I can quickly do that in excel? Maybe using the find function or something like that?
If you hide rows in one column then you hide them in all columns unfortunately.
Not all forums are the same - seek and you shall find
Advanced Filter would do what you need.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
What is advanced filter?
Its a tool for displaying only some of the rows. Which rows are Filtered to be shown is controlled by the cells in the Criteria range.
The help system has instructions and examples.
Your data needs to be organized with a unique header at the top of each column and no empty rows between data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mavsman4457 
Register To Reply
Bookmarks