+ Reply to Thread
Results 1 to 2 of 2

Filtering list of data based on criteria - Using formulas

  1. #1
    Registered User
    Join Date
    04-30-2017
    Location
    Philippines
    MS-Off Ver
    gilbertcristobal
    Posts
    17

    Exclamation Filtering list of data based on criteria - Using formulas

    This was one of the exam I encountered when I applied to one company. Need your help as I am curious and will definitely expand my knowledge in excel.


    Challenge is need to use formulas only. I already tried using Index combined with Small functions. But I can't incorporate the given criteria as it only accepts absolute value.

    Here's the scenario. Need to list down the fruits based on sales on a given criteria.


    1st criteria below $1500
    2nd criteria between $1500 - $2000
    3rd criteria above $2000


    See attached file for the detailed list of data. We should have the exact same list as shown in Sheet1.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Filtering list of data based on criteria - Using formulas

    Seeing as this was an exam question, we wont be giving you the answer directly, but we will assist and guide you to get what you need.

    With that said, what have you tried, what worked and what didnt?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Filtering data based on few criteria such as month, style, item etc
    By Anuru in forum Excel Formulas & Functions
    Replies: 117
    Last Post: 06-11-2017, 01:36 PM
  2. Replies: 1
    Last Post: 02-14-2017, 10:29 PM
  3. Filtering excel data based on criteria of interest
    By Mary22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 04:03 PM
  4. Filtering a list of Names from Worksheet1 onto Worksheet 2 based on specific criteria
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2014, 05:19 AM
  5. [SOLVED] Filtering Data based on Multiple Criteria
    By excelhelporfavor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-30-2013, 11:37 PM
  6. Filtering data based on criteria
    By rhudgins in forum Excel General
    Replies: 6
    Last Post: 04-15-2010, 02:03 PM
  7. [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

Tags for this Thread

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