In my excel sheet, I wanted to find the largest letter in a range raw-wise. Some cells in the range are blank cells. I tried the below formula but it didn't work for me. Please help me to solve this out

```
=CHAR(AGGREGATE(15,6,CODE(A1:A10),1))

```

![Screenshot of execel](https://i.stack.imgur.com/5TXSo.png)

Thanks!