ayush_mani
New Member
-
5
Select the language Select the language (English) English (Deutsch) German (Español) Spanish (Français) French (中文) Chinese (日本語) Japanese (한국어) Korean (Português) Portuguese-BR
Downloading translated content. Please refresh in few minutes.
Skip to Topic Message
Excel Implicit Conversion Operator causing problem
Discussion Options
Mani_ayush
NEW CONTRIBUTOR
Mar 20 2021 06:30 AM
Excel Implicit Conversion Operator causing problem
Hi all,
I am using an RPA Automation tool to write a FILTER formula. Problem is when I write that formula excel automatically adds the implicit conversion operator which makes my formula look like this : =@FILTER(A2:S477,R2:R477="A").
I did not write that @ in the formula using set cell value action in MS Excel VBO , that is something which excel added automatically.
I want to know how can I avoid this @ addition by excel.
I can't go ahead and manually delete this(which gives correct results) because I am using BluePrism RPA tool. So I'll be needing maybe a modification in the formula to get the same job done.
Any advices/suggestions are welcome