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:
I have attached my file.Please Login or Register to view this content.
Thanks in advance!
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:
I have attached my file.Please Login or Register to view this content.
Thanks in advance!
Try this array formula
=CHAR(MODE(IF(A2:H2="","",CODE(A2:H2))))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Or this non-array
=INDEX(A2:H2,MODE(MATCH(A2:H2,A2:H2,0)))
Last edited by AlKey; 09-10-2014 at 09:54 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
use the following array formula in cell I2:
Formula:Please Login or Register to view this content.
Also see attached - LETTERS.xlsx
Note: an array formula must be entered as Ctrl + Shift + Enter
HTH!
Thanks Alkey and jewelsharma! it works!
do you have a macro for this? i've just preferred it in a macro.
Mate, no idea why you need a macro for this. Alkey has given you a fantastic non-array formula.
However, if you must, try this:
Please mark the thread as 'Solved' and do consider adding reputation to Alkey for his brilliant formula.Please Login or Register to view this content.
Cheers!
Thanks both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks