# Complex copy&paste

1. ## Complex copy&paste

Hi guys,

I'm looking to copy all the values from "CV":
HmmLhOvKQEymu9O9DB-AmA.png

& paste them 1 place below:
ND_My-5BTEOtS_8UEpTcEA.png

Should be super easy, but it's a complete nightmare! Duplicating the column onto CW, moving the entire column down 1 place, then moving onto CV deletes the original data. Also doing a "find all" (i.e. "TRUE"), then copying & pasting, removes the placement of the data.

(I imagine the formula used to calculate "TRUE/FALSE" could be adjusted to always allow for the value below it to be true)

Formula for CV: =IF(BC2=1,IF(AND(L2<=2.88),TRUE),"") (should also point out that the data is ranked. i.e. BC3=2 = "TRUE" if BC1 matches the <=2.88 critera)

Any help would be much appreciated

2. ## Re: Complex copy&paste

Hmm don't really get what you mean. try adding \$ sign to your BC3 and L2?

=IF(\$BC2=1,IF(AND(\$L2<=2.88),TRUE),"")

then try copy again

3. ## Re: Complex copy&paste

Sorry, I worded it really badly!!

Basically, if "Rank 1" is true, I want "Rank 2" to automatically be labeled as true. Vice versa with false

mb9n9KSGT4CSXnuEx92j4w.png

4. ## Re: Complex copy&paste

oh ok sorry i didn't read carefully. so you mean if rank 1 is true the following rank 2 show true as well. and if rank 1 is false rank 2 show false as well is that what you mean?

How about the remaining rank 3,4,5,6,7 etc

5. ## Re: Complex copy&paste

If rank 1 is less than or equal to 2.88, show true. Then no matter what rank 2 is, show true also (The key is if rank 1 is true, rank 2 is true)

If rank 1 is false, then rank 2 is false.

6. ## Re: Complex copy&paste

Originally Posted by finalazy
oh ok sorry i didn't read carefully. so you mean if rank 1 is true the following rank 2 show true as well. and if rank 1 is false rank 2 show false as well is that what you mean?

How about the remaining rank 3,4,5,6,7 etc
That's exactly right

Ranks 3,4,5,6,7 etc are kept blank

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1