'In excel, how to find largest letter in a range which also contain some blank cells

In my excel sheet, I wanted to find the largest letter in a range. Some cells in the range are blank cells.

I have tried using a code obtained from a website, however it works only when there is no blank cell.

LOOKUP(2,1/(COUNTIF(D6:L6,">"&D6:L6)=0),D6:L6)

No output when some cells in the range are blank cells, i mean not all cells contain letter.

Sample data :

result is "B"

B   B   E   B   B   B   B   C

result in nothing (because not all 8 cells contain letter, 2 cells are blank).

B       E       C   C   B   C

excel-formula

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source