Hi all,
I have I have something like this below on excel. How do I pull the number "10100-000-00" from column "B" and move it over to "A" and then have it repeat until it hits a new number, which then repeats by itself?
Solved! Go to Solution.
Hi @Ahasan13
As it is an open ask, have tried all 3 possible outcomes as solution.
Please use the solution which suits your expected output.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @Ahasan13
Solution 2:
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @Ahasan13
Solution 3:
Where we can remove the row with same 10100-000-00 in both columns.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
this works but there is another issue, I have something thats call "Account" and then I also have something that's call "Legal Number:"
so this is what I wrote in on the formula below but it did not do anything for the "Legal Number" part. Please help
IIF([F1] = 'Account' and 'Legal Number:' , [F2],[Row-1:F1])
Hi @Ahasan13
Please find the expected output for both Account and Legal Number
IIF([F1] = 'Account' OR [F1]= 'Legal Number' , [F2],[Row-1:F1])
|Input was:
Many thanks
Shanker V