mescalante48
New Member
- Joined
- Sep 15, 2021
- Messages
- 29
- Office Version
- 2007
- Platform
- Windows
Hello everyone,
please see below, can we remove all zeros from one column and take only the nonzeros values to a different column?
looking for a formula to do this, no arrays, please.
please see below, can we remove all zeros from one column and take only the nonzeros values to a different column?
looking for a formula to do this, no arrays, please.
![4b54540025b0f4bf51620d32f8c65756.png](/board/proxy.php?image=https%3A%2F%2Fgyazo.com%2F4b54540025b0f4bf51620d32f8c65756.png&hash=81d422af2e13950ae5d9148f2dcb9db8)