Log In
Register
Home
New Member
May 11, 2022
Offline
Hi,
I've been looking through a few videos and threads trying to work out a solution. I have managed to write code to move the rows to a new document and auto filter and remove certain rows however I can't work out the following.
I have a list of submission numbers in column B sometimes these submissions return with an error and need resubmiting, I can't work out how to code it so that scans column B and if the submission ID duplicates and in one of the duplicate rows column R = "Success" it deletes both rows?
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Perhaps clear in your mind, but please upload the work you have done so far. Then it becomes much easier to diagnose and fix the problem.
New Member
May 11, 2022
Offline
Hi,
I've been looking through a few videos and threads trying to work out a solution. I have managed to write code to move the rows to a new document and auto filter and remove certain rows however I can't work out the following https://xender.vip/ https://nox.tips/ .
I have a list of submission numbers in column B sometimes these submissions return with an error and need resubmiting, I can't work out how to code it so that scans column B and if the submission ID duplicates and in one of the duplicate rows column R = "Success" it deletes both rows?
I got this,...
1 Guest(s)
