Here's my problem. I have a column of roughly 1100 cells of data. Through a series of formulae and logic, I've reduced it to an identically sized column with most of the values zero, and 10-15 nonzero. What I want to do is pull all the nonzero values out of this column and record them in the next column over. I realize I could do this just by sorting the data, but I'd like to know if there's a way I can have excel do this step for me.
Any ideas?
Thanks!
Any ideas?
Thanks!