1. S

    formula corrupted by query resultset changing

    i have a worksheet tied to a TFS query to retrieve work items from that system. The results of which are displayed in $B:$D. In column A I need to have a formula that examines column D and potentially massages the data - something like...
  2. E

    Query refresh is altering COUNTIFS range

    I have built a dashboard sheet that references information on other sheets that are updated by refreshing queries against TFS. At times (but not always), my dashboard cells will bang out to #VALUE! because my formula =COUNTIFS('Sheet2'!$A$3:$A$5000,$B4,'Sheet2'!$K$3:$K$5000,F$3) becomes...

Some videos you may like

This Week's Hot Topics