Results 1 to 5 of 5

Generate Records from Countifs Results

Threaded View

  1. 12-08-2016, 01:10 PM #1
    billgyrotech
    billgyrotech is offline
    Banned User!
    Join Date
    03-06-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    295

    Generate Records from Countifs Results

    I have an attached file for calibrations. On Sheet1 I have a countifs formula in "C5" to produce the number of occurrences of dates due (Calibration Log!J8:J23) within a selected date range (Sheet1!C2 to Sheet1!C3) from the "Calibration Log" worksheet. Is there a way to have those records (every row within the date range) show up on Sheet1 ?

    Thank you very much for any help or suggestions.
    Attached Files Attached Files
    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. [SOLVED] Countifs - Include specific or any records
    By Ifthenpoop in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-03-2016, 05:17 PM
  2. Macro to generate 1K files from source excel file with unique records in 2 cell
    By mak177 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2015, 02:41 AM
  3. Loop through rows and generate new records
    By JessPedersenSCM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 09:39 AM
  4. [SOLVED] Generate List of Records that Match Multiple Criteria from Data Table
    By trandle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-10-2014, 04:43 PM
  5. CountIFs results excluding duplicates
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-09-2014, 10:38 AM
  6. [SOLVED] Countifs results in 0 with Date range
    By kevindub in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-07-2013, 01:35 PM
  7. How to generate lottery numbers from past records
    By icongene in forum Excel General
    Replies: 5
    Last Post: 06-24-2012, 06:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1