Hi, I'm still learning Excel and need help with a formula. I have a column T I have positive numbers scattered out in 5 cells in the range T2:T100 (I have a formula in range T2:T100 that returns "" if the result is = 0 so most of the cells are blank except for the hidden formula) I need to find the cells that are > 0 in range T2:T100 and put them in T105:T110 and also give me the values in column S in S105:S110. Hope this is clear and thanks for your help.
This question generated 26 answers. To proceed to the answers, click here.
This thread is current as of February 02, 2014.