阅读背景:

Reduce and speed up multiple regexreplace formula

来源:互联网 

I use this loooooong formula to check if data in cell A33 is have regexmatch pattern from cell INDEX('categories'!$A:$A;1;1) - cell A4 - if its true, I use regexreplace patterm from cell INDEX('categories'!$B:$B;1;1) - cell B4. If its not - I go and check the next cell with regexmatch pattern - ('categories'!$A:$A;2;1) - cell A5. And do it until I find right pattern, or until reach the last cell A30 which have pattern A30 ="^.I use this loooooong formula to check if data i




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: