On column A3:A15 I have a series of numbers with decimals. 10.2, 13.21, 45.26 and so on. I wrote the following formula:
=SMALL(IF(ISNUMBER(SEARCH(B3,A3:A15)),ROW(A3:A15),""),1)
By typing a decimal in B3, such as …21, it will give me the row number for the cell with 13.21. But if I type …20 it will find nothing. If I switch it to .0.2 it will find the row number for the cell with 10.2. But if change the formula to this:
=SMALL(IF(ISNUMBER(SEARCH(B3,A3:A15)),ROW(A3:A15),""),2)
and I type .0.2 on B3, it will give me the row number for 13.21.
What can I type on B3 so it can inly detect numbers with .2 but not .21, .22, .23, etc?