Complex copy&paste

[Median]

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

[finalazy]

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

[Median]

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

[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

[Median]

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.

[Median]

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