ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filter (https://www.excelbanter.com/excel-discussion-misc-queries/109726-filter.html)

Sam

filter
 
I want to filter a worksheet based on one column, and have the data in all
other columns remain with their records.

Dave Peterson

filter
 
That's the way data|filter should work.

Is something else happening?

Sam wrote:

I want to filter a worksheet based on one column, and have the data in all
other columns remain with their records.


--

Dave Peterson

JLatham

filter
 
Data | Auto Filter is probably the fastest way to do this.

Are you sure you mean filter, or do you perhaps mean Sort?

"Sam" wrote:

I want to filter a worksheet based on one column, and have the data in all
other columns remain with their records.



All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com