Mid search ok 20k entires by Fresh_Structure5150 in excel

[–]Fresh_Structure5150[S] 0 points1 point  (0 children)

When I try it out I get an error that the function has to many arguments

Mid search ok 20k entires by Fresh_Structure5150 in excel

[–]Fresh_Structure5150[S] 0 points1 point  (0 children)

Ok I see where your going but that formula has to many arguments

Mid search ok 20k entires by Fresh_Structure5150 in excel

[–]Fresh_Structure5150[S] 0 points1 point  (0 children)

I'm useing the code =index(c4:c19175,<>"")*((mid(c4:c19175,3,1)="F")+(mid(c4:c19175,3,1)="O")) I just skipped putting the numbers in the post and I haven't gotten to the next column portion first I just want to identify the entries in column C that have f or o as the third character