Hello
I am new to this forum and would appreciate some help.
My query is this.
I have various positive amounts in each field and one negative amount. there are hundreds of rows and 50 odd columns. the negative amount could be in any column. Is there a way that I can enter in the last column a formula to find the negative amount and put that amount in that column.
I mean something like a lookup or Find..
Many thanks
I am new to this forum and would appreciate some help.
My query is this.
I have various positive amounts in each field and one negative amount. there are hundreds of rows and 50 odd columns. the negative amount could be in any column. Is there a way that I can enter in the last column a formula to find the negative amount and put that amount in that column.
I mean something like a lookup or Find..
Many thanks