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.
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.