Results 1 to 8 of 8

Generate a list based on meeting a criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-02-2015
    Location
    Toronto, ONtairo
    MS-Off Ver
    Office 2013
    Posts
    4

    Generate a list based on meeting a criteria

    Hi all, this is my first post here. Hoping you all can help !

    I'm currently running a large data pull and am trying to come up with a convenient way to generate a list of all the items in the table that meet a certain criteria. What would be the best way to do this? / What would be the appropriate code to do this.

    If a cell is greater than 80, than report the class, day and % total

    TABLE/INPUT

    DAY#
    Class 1 2 3 4 5
    A 76 33 91 107 52
    B 23 5 104 72 33
    C 52 88 86 95 97

    OUTPUT:

    Class Day %total
    C 2 88
    A 3 91
    B 3 104
    C 3 86
    A 4 107
    C 4 95
    C 5 97

    Book1.xlsx
    Last edited by nekomi15; 07-02-2015 at 01:27 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : How to generate a list based on criteria
    By fraggle in forum Excel General
    Replies: 7
    Last Post: 05-20-2015, 04:41 AM
  2. Generate Unique List Meeting Criteria
    By ictodd in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-22-2014, 03:06 AM
  3. Generate list of names based on multiple criteria
    By mattadler22 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 06:02 PM
  4. Replies: 2
    Last Post: 03-30-2011, 08:05 PM
  5. Record Symbols from Changing List Based on Meeting Various Criteria in Other Cells
    By DrSues02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2007, 05:20 PM

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