Closed Thread
Results 1 to 9 of 9

Most Common text result in a selection If certain value present

Hybrid View

AMeloche Most Common text result in a... 06-18-2015, 06:24 PM
Kaper Re: Most Common text result... 06-22-2015, 06:40 AM
AMeloche Re: Most Common text result... 06-24-2015, 03:33 PM
Kaper Re: Most Common text result... 06-25-2015, 07:15 AM
AMeloche Re: Most Common text result... 06-25-2015, 11:07 AM
AMeloche Re: Most Common text result... 06-25-2015, 11:16 AM
Kaper Re: Most Common text result... 06-26-2015, 04:11 AM
AMeloche Re: Most Common text result... 06-26-2015, 03:36 PM
6StringJazzer Re: Most Common text result... 06-27-2015, 10:25 AM
  1. #1
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Most Common text result in a selection If certain value present

    In K4 on "Display Sheet":
    Formula: copy to clipboard
    =COUNTIFS('PCC Call Data'!$F$3:$F$458,"<>",'PCC Call Data'!$J$3:$J$458,H4)
    and copy down
    Best Regards,

    Kaper

  2. #2
    Registered User
    Join Date
    06-18-2015
    Location
    Toronto, Ontario
    MS-Off Ver
    Mac 2011
    Posts
    67

    Re: Most Common text result in a selection If certain value present

    THANKS KAPER! !

    Lastly, I want to (without a pivot table) be able to select a month's worth of data (using a dropdown list and an IF statement) and display the practice-specific data on the 'Display Sheet". The data would come from the 'PCC Call Data' sheet.

    Example: Select "June" from dropdown list and the practice-specific data on the 'Display Sheet' will show the data only for June (the months are separated in the 'PCC Call Data' sheet)

    I realize this is a large endeavour. Thank you for any possible he

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy common number present in multiple rows
    By vanitarathod in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2014, 06:57 AM
  2. Replies: 1
    Last Post: 08-14-2013, 10:41 PM
  3. [SOLVED] Help needed, search in database and present result.
    By Nikorasu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2012, 11:05 AM
  4. Can't seem to get the automatic selection of data present down!
    By wantucce in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-18-2008, 04:51 AM
  5. Finding the most common (and 2nd, 3rd most common) text
    By sprite_green in forum Excel General
    Replies: 2
    Last Post: 11-23-2006, 11:56 AM

Tags for this Thread

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