+ Reply to Thread
Results 1 to 5 of 5

Filtering 3X5

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Houston, Texas
    MS-Off Ver
    2013 pro plus
    Posts
    73

    Filtering 3X5

    Hi guys,

    Very new to VBAs but was wondering if this was possible.

    I have a large data set which shows sales folks and number of different products they sold (6 total products). I want to be able to click a button and for the data to filter on those that have sold at least 5 sales in atleast 3 different products.

    Is this something that can be done?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Filtering 3X5

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Houston, Texas
    MS-Off Ver
    2013 pro plus
    Posts
    73

    Re: Filtering 3X5

    Thanks,

    I have added an attachment. The data is from column A to S, whereas anything after is mocked up to see if I can replicate this via VBA. Again if any sales person is selling more then 5 of any product i want a yes and at the end to note if they are hitting 3x5
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Filtering 3X5

    Please see attached,

    Your sample with the buttons

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-23-2018
    Location
    Houston, Texas
    MS-Off Ver
    2013 pro plus
    Posts
    73

    Re: Filtering 3X5

    This is amazing! Is there a way to add up at the end how many product >5 they are selling? for example 3 out 56 or 4 out 6 or 5 out 6

+ 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. (edited title) BUG filtering for blanks (or filtering out all empty rows)
    By zextrot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-22-2017, 01:51 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. [SOLVED] Easy filtering method via vba/formula/advanced filtering?
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 12:35 AM
  4. [SOLVED] trouble filtering a list. Why isn't column filtering?-number of criteria
    By Pat in forum Excel Formulas & Functions
    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