Hello,
I'm having an issue with a formula and I'm hoping to get some assistance. I apologize if this has been covered before, but I did a search and didn't have any luck.
So I have a sheet with accounts in the first column, budgets across the top row, and a variety of values in the range:
Budget1, Budget2, Budget3, Budget4, Budget5, etc...
Account1 0 0 0 0 0
Account2 250 0 -750 2100 7
Account3 -21 100 0 0 75
Account4 -75 80 25 5 -5
Account5 500 0 50 -6 0
I'm trying to pull in *ONLY* the non-zero values to a second sheet in just in a column in a list form. Also, ideally I'd be able to pull in the account and budget in two adjacent cells, but the main thing is just eliminating the zeros since they are not needed for what I'm trying to do.
Any assistance that you can provide would be greatly appreciated!
Thanks!
Chris
Bookmarks