+ Reply to Thread
Results 1 to 2 of 2

Using filters, and then unselecting filters. Organizing data.

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Using filters, and then unselecting filters. Organizing data.

    Hi all,

    So lets say

    Column A: Products
    Column B: Prices
    Column C: Stock

    Now I filter Column B and I see the products that fit my criteria in Column A.

    If I deselect Column B, I lose all the Column A products I was looking for.

    How do I filter Column B and then select Column A and deselect Column B while maintaining Column A's filters that was selected via Column B.

    Hope that makes sense!

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Using filters, and then unselecting filters. Organizing data.

    You can either sort the whole data with col b. Or after filtering data in col b col color those data that appear in col a
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

+ 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. Replies: 7
    Last Post: 07-15-2019, 03:06 AM
  2. forumla that filters data together
    By hasanbirol in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-17-2012, 09:49 AM
  3. Replies: 4
    Last Post: 07-24-2012, 01:21 PM
  4. Data Filters
    By bmasella in forum Excel General
    Replies: 0
    Last Post: 05-09-2007, 02:39 AM
  5. [SOLVED] Data Filters
    By Crissyb in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 08:40 PM

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