Trying to find a formula to fill 0 values with the first non zero value to the right of it. In other words non zero cell value needs to fill all zero cells to the left of it.
The attached image shows it done in columns filling values AFTER each but I need it to occur BEFORE.
I feel like a writer writing a novel with writers block on Chapter ONE
To avoid confusion, I need it to work within a certain ROW instead of COLUMNS.
The attached image shows it done in columns filling values AFTER each but I need it to occur BEFORE.
I feel like a writer writing a novel with writers block on Chapter ONE
To avoid confusion, I need it to work within a certain ROW instead of COLUMNS.
Last edited by a moderator: