Results 1 to 4 of 4

Count number of times when data is highest among a column

Threaded View

arrontan Count number of times when... 05-15-2013, 05:39 AM
ARGK Re: Count number of times... 05-15-2013, 07:21 AM
arrontan Re: Count number of times... 05-15-2013, 10:22 PM
ARGK Re: Count number of times... 05-20-2013, 06:10 AM
  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Count number of times when data is highest among a column

    hello everyone,

    i am new here, and learning to use the advance excel functions.
    currently i am stuck on a project where i am suppose to calculate each day, the number of times A is the highest against its competitors (B to L).

    using the attached excel worksheet 0506-0512, i have grouped my data by channels, starting with A (row 107) where you can see daily stats by the hour. this is followed suit for other channels B to L as you scroll down.

    i am trying to find out the number of times in a day where my channel, A, is the highest compared to channels B to L. similarly i wish to do it the other way round where i can see number of times where competitors is the highest compared to my channel but excluding zeros.

    any kind souls can help me figure this out? or do i actually need to build MYSQL to do this?
    much appreciate!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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