logical test and concatenate(string)
Would this work?
assuming you are currently placing the formula in cell C1:
Cell C1: =if(a1<0,a1&" "&b1&","&" ","")
Cell C2: =C1&if(a2<0,a2&" "&b2&","&" ","")
Cell C3: =C2&if(a3<0,a3&" "&b3&","&" ","")
etc...
copy this down to the last row, data in column C of that row should contain
everything...maybe?
"dpayne" wrote:
I am looking for a formula that will find non zeros in column A and string
columns A & B, where there are a least 50 rows of information. The stringed
cells should be seperated by "," and a space. I have the following formula
but it becomes to big to fit in the cell.
=if(a1<0,a1&" "&b1&","&" ","")&if(a2<0,a2&" "&b2&","&" ","")&if(a3....etc)
I appreciate the help
|