• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to remove the 2nd duplicated number between 2 fixed varibles in next column?

E

elmer

New Member
Dear Colleagues,


May I ask how to solve aforesaid matters by having the following example? In this case, how to remove the 2nd "1"(or change "1" to "0") in column A which is located between the first and second "3" in column B.


A,B

0,3

1,0

0,0

1,0

0,3

1,0

0,3

0,3

1,0


The above list length is around 10,000.


Look forward to hearing from you soon!


Elmer
 
Hi Elmer ,


I am sorry I cannot understand your full requirement ; the example you have given is just one example ; what is supposed to happen in the remaining 10,000 rows ?


Can you please explain in more detail ?


Narayan
 
ultimately, I would like the above list to be shown as follows:


A,B

0,3

1,0

0,0

0,0

0,3

1,0

0,3

0,3

1,0

0,0

0,0

0,3

1,0

0,3

0,0

0,3

1,0

0,0

0,0

0,0

0,0

0,0

0,3

0,0

0,3


Hence, between 3 and 3 in next column, there should be only ONE "1".


My original list is below:

0 0

1 0

0 3

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1 0

0 3

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 3

1 0

0 0

0 3

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

1 0

0 3

0 0

0 0

0 0

0 0

1 0

0 0

0 3

0 0

0 3

0 0

0 0

1 0

0 0

0 0

0 0

1 0

0 0

0 0

1 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1 0

0 0

0 3

1 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 3

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 3

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

1 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

1 0

0 0>
0 0

1 0

0 0

0 3

1 0

0 0

0 0

0 0

1 0

0 3

0 0

0 0

0 0

0 0

0 0

0 3

0 0

1 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 3

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3

1 0

0 3

0 0

0 0

0 0

0 0

1 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 3

0 0

0 0

0 0

0 0

0 0

1 0

0 0

0 0

0 0

0 3

0 0

0 0

1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 3
 
Hi Elmer ,


Can you check out the following workbook ?


https://docs.google.com/open?id=0B0KMpuzr3MTVUjJvbXkzcVM5bFE


I have used 2 helper columns ; is this acceptable ?


Narayan
 
You must log in or register to reply here.
Back
Top