+ Reply to Thread
Results 1 to 4 of 4

How to list down the Serial No. by date range

  1. #1
    Registered User
    Join Date
    12-15-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to list down the Serial No. by date range

    Hello,

    Can someone help me out of these.


    As attached. I want C4 to list down the Serial No. by date range.

    Ty in advanced.
    Attached Files Attached Files
    Last edited by pakida; 08-29-2018 at 10:26 PM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to list down the Serial No. by date range

    Thanks for the title change.

    Try array entering this in cell C4 of 'Sheet1'. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Also:
    Your profile says Excel 2003. The upload is a newer format.

    Please update your profile to reflect what version(s) you are using. Members tailor solutions with that in mind. In this case there are other solutions that won't work in 2003.
    Dave

  3. #3
    Registered User
    Join Date
    12-15-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: How to list down the Serial No. by date range

    Thank you for your help. Sorry I didn't notice my profile since I'm using another PC. Will change soon.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to list down the Serial No. by date range

    You are welcome. Thank you for the feedback and added rep.

    Does the formula do what you want with the real data?

+ 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. trying to do countif using index match
    By superchew in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-01-2016, 01:09 PM
  2. [SOLVED] Help with index match/countif?
    By ExcelNUBs in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-07-2013, 01:12 PM
  3. [SOLVED] VBA - Countif, Index and Match
    By ggentry in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2013, 09:15 AM
  4. Countif/Match Index
    By skate1991 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2013, 12:43 PM
  5. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  6. Countif, index, match
    By n1kk1 in forum Excel General
    Replies: 7
    Last Post: 05-12-2010, 10:13 AM
  7. [SOLVED] Countif, Index, Match... not sure which to use
    By Amy via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2005, 06:05 PM

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