Duplicate Cell value if another cell meets criteria

asked 2016-09-29 19:53:30 +0200

JG101 gravatar image

How do I Duplicate Cell value if another cell meets criteria

please see document with description

thank you in advance for anyone who helps with Answer(s) Cell Value duplicate if Cell equals 1 09-29-2016.ods

edit retag flag offensive close merge delete

Comments

1

IMHO you need =IF(K5=1; D5; "")

JohnSUN gravatar imageJohnSUN ( 2016-09-29 19:58:26 +0200 )edit

Great, that is what I needed. Thank you!!!!!

JG101 gravatar imageJG101 ( 2016-09-29 23:02:48 +0200 )edit