R
Ron Howard1
Guest
Let me say this first I tried len(clean(trim and check string using mid and and the value is correct format correct on sheet1 and sheet3 too I am using index and match ,on sheet 3 I have values in f:f from 28.0 to 22.0 and g:g almost the same but values can repeat in different cell so here’s my problem in f3 I have 27.8 and it works correctly and in f5 27.6 it works correctly but f4 has 27.7 and it returns value of n/a it does this on only anything that has .7 so I make another using column J and k and it has same problem but it is with anything with . 6. Like 27.6 I added value, trim, array
Continue reading...
Continue reading...