+ Reply to Thread
Results 1 to 4 of 4

Most Popular Entry by Month

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Most Popular Entry by Month

    use a pivot table!

    Post your data, I'll talk you through how

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Most Popular Entry by Month

    If a PT is not viable given your tabular requirements and/or result being non-numeric value (ie not viable in PT data field) you can adjust the previous formula as so:

    =LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX('All Incidents'!$D$1:$D$1085,MODE(IF(('All Incidents'!$D$1:$D$1085<>"")*('All Incidents'!$O$1:$O$1085=1)*ISNA(MATCH('All Incidents'!$D$1:$D$1085,$E$10:$E10,0)),MATCH('All Incidents'!$D$1:$D$1085,'All Incidents'!$D$1:$D$1085,0))))))
    
    Committed with CTRL + SHIFT + ENTER
    The alteration is in red - and obviously reference to 1 can be altered to be a cell containing value of interest.

+ Reply to Thread

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