Results 1 to 4 of 4

Filter and Sort

Threaded View

siobeh Filter and Sort 05-02-2014, 04:56 PM
daffodil11 Re: Filter and Sort 05-02-2014, 06:10 PM
siobeh Re: Filter and Sort 05-02-2014, 11:46 PM
siobeh Re: Filter and Sort 05-03-2014, 04:55 AM
  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Filter and Sort

    Hello,

    Could you please help me with my problem.
    I just want to filter and sort the data based on names and hours.

    Here it goes:

    1. Filter Column F.
    2. Filter it by: UK & M UK
    3. After that, filter Column E in "Ascending order"
    4. Count the data that are:

    -starts 1:01AM - 7:59AM and display the total count in Sheet2, if there are no data in other specific time, then display a value "0"

    For example for UK and M UK:

    In Sheet 2, ("F5") = 3 as there are 3 data, G5=1, H5=0 and so on and so forth..

    I've attached my file. Thank you gurus and more power to this forum!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can't Sort or Filter
    By JXBlack in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 10-25-2017, 01:35 AM
  2. [SOLVED] Help : Sort & Filter
    By sarahqputra in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-10-2014, 02:57 AM
  3. Sort/filter
    By cowboy713 in forum Excel General
    Replies: 6
    Last Post: 11-22-2010, 06:40 PM
  4. Sort and Filter
    By prodgerson in forum Excel General
    Replies: 1
    Last Post: 07-11-2010, 02:01 AM
  5. Filter with Sort
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2009, 05:14 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1