excel - Fill certain cells with value above them -
i have info range transform this:
before: after: po001808 |po001808 po001808 |po001808 false |po001808 false |po001808 false |po001808 po001845 |po001845 po001845 |po001845 po001845 |po001845 false |po001845 false |po001845 i trying fill cells have false, value above them, repeat process when new value reached. have utilize vba formula or possible simple functions?
in after column, cell b2:
=if($a2=false,$b1,$a2) and drag down.
excel vba cell
No comments:
Post a Comment