Using IF LARGE when there is text in column
- by Ray
I have an excel column of numbers and texts. I tried to use "IF LARGE" to find top 3 numbers of the column (A1 to A7), and return "Yes" to the cells right next to the top 3 (in column B). But unfortunately, the cells next to the texts also returned "Yes". This is the data:
0.2
0.3 Yes
0.5 Yes
0.1
0.8 Yes
asdf Yes
jklm Yes
This is the code for cell B7:
=IF(A7>=LARGE($A$1:$A$7,3),"Yes","")
Any suggestions to fix this? thanks in advance