Search results for query: *

Formula in a cell would work.

I need to get totals from a pivot table onto another sheet but when I refresh the column changes. Is there a way to reference a pivot table column that is not static???

In Column A I need a way to go to end of column A and go up to first row where there is word like "Afni" then copy down to 1st empty row cut and paste A and B into Column C and D then keep find next row with word like "Afni" and then copy down to 1st empty row cut and paste A and B in Column E...

I fixed it .... Thank you

Thank you - that works, but do not need to put in Column C - can we change to place total in Column B? Works great...

Soccercook44 - Yes

I need to sum the rows in Cell B that is blank the rows below it before the next empty cell and need to do in a loop. The City, State are the blank cells. A B Charleston, SC Hamilton,V 1 Northeast, Charlotte NC Smith,F 1...

I am trying to copy a formula and the column I am trying to match has a space between the name "Colorado Springs" when I try to paste the formula - it does not recognise the name and thus does not copy the formula.....

I am getting a error group condition not allowed on the else sum line - I am needing to add TalkTime, HoldTime and Worktime if {vwEST.CallsAnswered}<= 0 then 0 else sum({vwEST.TalkTime},{vwEST.HoldTime},{vwEST.WorkTime}) /{vwEST.CallsAnswered}