I am having one excel with header as “car, name and purchase”.
So we have to write purchase value “40000” in front of name. But is it possible to filter “name” column and then update rather than updating each row.
For ex. “name column having value Andrew” so BOT have to pick all “andrew” and update purchase value in front of that row which having name as “andrew”.
test.xlsx (11.0 KB)