Excel 2016
I have imported a database onto excel consisting of approx. 200 columns and 12,000 rows. Each column has different values (5 and 9-number zip codes, name, range, address, number, state, %, etc.).
Sample Rows:
- 00850 (zip code)
- Noname Company
- 100 Address Street
- 10-25%, Up to 10%
- $40,000
- CA
Each row has a unique ID #, and I am currently using advanced filter for find rows located in certain zip codes. After I have filtered by zip code, I copy the ID #s onto another sheet and use VLOOKUP to show the most important columns for a more printer-friendly layout.
I am wondering if there is a way I can use multiple filters and sorting before I copy the ID #s. For example, filter by using the zip code tool, 50-75%, $5,000-$10,000 (I have tried uncecking and checking boxes under filter, but it takes a very long time). When I use the advanced filter tool for zip codes, I am not able to use other filters without it deleting my advanced filter and vis versa.
If there is another way to filter or sort multiple columns, or even putting a search bar at the top of the rows, without implementing any macros, it would make my life a lot easier. Please let me know.
Thank you.
I have imported a database onto excel consisting of approx. 200 columns and 12,000 rows. Each column has different values (5 and 9-number zip codes, name, range, address, number, state, %, etc.).
Sample Rows:
- 00850 (zip code)
- Noname Company
- 100 Address Street
- 10-25%, Up to 10%
- $40,000
- CA
Each row has a unique ID #, and I am currently using advanced filter for find rows located in certain zip codes. After I have filtered by zip code, I copy the ID #s onto another sheet and use VLOOKUP to show the most important columns for a more printer-friendly layout.
I am wondering if there is a way I can use multiple filters and sorting before I copy the ID #s. For example, filter by using the zip code tool, 50-75%, $5,000-$10,000 (I have tried uncecking and checking boxes under filter, but it takes a very long time). When I use the advanced filter tool for zip codes, I am not able to use other filters without it deleting my advanced filter and vis versa.
If there is another way to filter or sort multiple columns, or even putting a search bar at the top of the rows, without implementing any macros, it would make my life a lot easier. Please let me know.
Thank you.