+ Reply to Thread
Results 1 to 6 of 6

Filtering a column of States

  1. #1
    Registered User
    Join Date
    07-16-2017
    Location
    Ridgeland Mississippi
    MS-Off Ver
    2013
    Posts
    2

    Filtering a column of States

    I have a data base from my retail store containing 6000 names, addresses, I want to filter the state of MS my residence state MISSISSIPPI . When i select the filter icon , the small box comes up for all the columns. i go to the one under state and select none then select MS. This data base has been downloaded from my POS system which is associated with my POS that is cloud based It comes to me as a CSV . I click ok and the states are removed all except MS. Then i save as and place it on the desk top. Open it again and all the states are back in the list ????????

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,637

    Re: Filtering a column of States

    Filter doesn't remove anything, it just hides the rows. You want to remove them?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,963

    Re: Filtering a column of States

    Use the Advanced Filter Option with the output to a different worksheet. Then save that worksheet as a .csv file

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,637

    Re: Filtering a column of States

    Perfect .

  5. #5
    Registered User
    Join Date
    07-16-2017
    Location
    Ridgeland Mississippi
    MS-Off Ver
    2013
    Posts
    2

    Thumbs up Re: Filtering a column of States

    Many Many thanks for the prompt reply. GREATLY APPRECIATED!!!!!!!!! TO SHG AND ALANSIDMAN

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,963

    Re: Filtering a column of States

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ordering states in a pivot table so that United States appears at the bottom
    By cmcgath in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2014, 05:29 PM
  2. [SOLVED] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  3. Excel Formula to extract top 5 states from column.
    By KINNEY0201 in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 08-23-2010, 07:40 PM
  4. trouble filtering a list. Why isn't column filtering?
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. Replies: 1
    Last Post: 07-18-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1