Results 1 to 14 of 14

List cell entries based on numerical criteria

Threaded View

  1. 05-16-2016, 11:39 AM #1
    jcswaby
    jcswaby is offline
    Registered User
    Join Date
    03-08-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    33

    Question List cell entries based on numerical criteria

    Hi I've been racking my brains on this for a couple of hours. I want to produce a summary list on sheet 1 of all account numbers (Sheet 2, column A) which have a value below 5000 (sheet 2, column B). I have searched using various terms but they all keep pointing out COUNTIF functions, I know the number of accounts, I just don't know which accounts.

    Your help is greatly appreciated.
    Attached Files Attached Files
    Last edited by jcswaby; 05-17-2016 at 04:02 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display unqiue text entries in a list based on date criteria
    By lookingforhelp1 in forum Excel General
    Replies: 7
    Last Post: 08-21-2015, 03:14 PM
  2. [SOLVED] Place text in a specific cell based on two separate drop down list entries
    By fazthfc in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-24-2015, 03:34 PM
  3. [SOLVED] Combine cell entries based on criteria
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-13-2014, 01:00 PM
  4. Macro to copy a sheet/template in a based on numerical cell value or list
    By hodda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 03:11 PM
  5. List entries in userform based on criteria
    By h0ps in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2013, 09:22 AM
  6. counting non-numerical in a list with blank entries
    By SoE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2010, 04:07 PM
  7. Excluding Numerical Characters Based on Criteria
    By NewExcelUser in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2008, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1