Results 1 to 6 of 6

Count highest number of letter in a cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Count highest number of letter in a cell

    Hello gurus,

    I just want to count the highest number of letters in a cell and display that letter in column I2.

    For example i have the below data:
    A2 = A
    B2 = A
    C2 = Z
    D2 = Z
    E2 = Z
    F2 = E
    G2 = R
    H2 = F
    
    in I2, it should display "Z" because it is the highest number of letter in the cell.
    I have attached my file.
    Thanks in advance!
    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. count number of times the letter "a" appears in a cell
    By mohammadkhajoo in forum Excel General
    Replies: 8
    Last Post: 05-31-2014, 07:48 PM
  2. Replies: 5
    Last Post: 07-05-2012, 04:04 PM
  3. [SOLVED] How to count a cell with a number or letter as 1 or an empty cell as 0
    By garrett.grillo in forum Excel General
    Replies: 4
    Last Post: 03-05-2012, 09:44 AM
  4. Replies: 5
    Last Post: 06-27-2006, 09:10 PM
  5. count a number range and a letter in a cell
    By santaviga in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2006, 06:15 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