Results 1 to 12 of 12

Formula for counting text values in column when value is repeated in cells

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Swindon, England
    MS-Off Ver
    Excel 2007
    Posts
    15

    Formula for counting text values in column when value is repeated in cells

    In the uploaded workbook I have 2 active sheets. Sheet1 and Calling Sheet.

    In "Calling sheet" Column Y lists the results of calling activity.

    On "Sheet1" there are 4 cells B1:B4 I need a formula that will count the initials of the staff members in the notes in they column y cells in the "Calling Sheet". So Mark Weaver is MW, Jim Saunders is JS....

    I need a formula that will count the amount of times the initials of the listed people appear in the notes in column y. Bear in mind that in each cell the initials can be entered multiple times on new "Alt&Enter" lines.

    So in conclusion I really need some help here!!
    Attached Files Attached Files
    Last edited by Blubirdjim; 12-11-2012 at 12:25 PM.

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