+ Reply to Thread
Results 1 to 4 of 4

Display with first three text name with highest number of records based on date

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Display with first three text name with highest number of records based on date

    Hello Everyone!

    In the attached sheet, I want to display check name with total records for individual one from Columns J to O in template sheet.

    Please check that all date sheet (i.e. 01-Dec-2013, 02-Dec-2013 etc) contain a variable "Download_DT" from which the formula should filter only date with sheet name.

    i.e. for sheet 01-Dec-2013, different date are there in column Download_DT 27/11/2013 20:34,
    28/11/2013 20:34
    01/12/2013 20:34

    Advance thanks
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: Display with first three text name with highest number of records based on date

    Please see the file
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Display with first three text name with highest number of records based on date

    I am not getting proper output. It should match with the output which I have provided. (The formula will only filter data with date mentioned in the sheet)


    Is it possible for you to populate the same in Columns J to L. along with total records from M to O

    J--highest record
    K----second highest
    L--third highest

  4. #4
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Display with first three text name with highest number of records based on date

    can anyone help me whether its possible or not

+ 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. Work out highest number and display another column
    By danielseward408 in forum Excel General
    Replies: 3
    Last Post: 08-21-2012, 03:51 PM
  2. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  3. Complete Text to Display Based on Number
    By BlastRanger in forum Excel General
    Replies: 2
    Last Post: 09-30-2010, 04:39 AM
  4. Display Highest Number??
    By softz in forum Excel General
    Replies: 2
    Last Post: 07-06-2009, 12:09 AM
  5. display number of years based on a date
    By hoser in forum Excel General
    Replies: 2
    Last Post: 03-28-2009, 01:51 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