I have a Excel Sheet Like this :
What I want to Do is In the Stock Available Code Column Where Ever There is #N /A mentioned In the Remarks Column It should write as Stock Not Available
The Final Sheet Should Look like
Any Help is appreciated
The Sample Excel Sheet -
Book1.xlsx (9.0 KB)
Hey,
You can Use Read Range Activity Then
For Each row Activity
then in If condition you should mention
Current row(“Stock Available Code”).equals(“#N /A”)
then
write Cell
“Stock Note Available”
Else Condition
Continue Activity
Thanks
Hey
You can use this workflow
Main.xaml (8.5 KB)
Book1.xlsx (9.1 KB)
Thanks
This was not I was Looking For.
My Cell is not Empty It has a value #N /A
hey.
this is considering as empty cell
please keep the value in message box you will get understand
its not reading #N /A
Thanks
system
(system)
Closed
August 1, 2022, 10:31am
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.