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. .">
Most valuable professional
  • Hot Topics

Excel Formula question

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 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel