nsw

Hello, Looking to do a COUNTIF statement I believe. We are looking to find a particular salesperson in this instance Caitlin which is located in column B and then looking for STATE in column E if this is TRUE then total the values found in column H against all the lines found. The formula...

I've spent quite some time trying to figure this out, but can't - seeking assistance from those with far better skills than I. I am trying to calculate the number of days between two dates (A2 & B2) excluding: weekends, holidays (by state) as well as for a ticket received before or after 1PM...

I can't seem to change my pivot table header name. What I usually do to do that is: 1. Click within the Pivot Table 2. Go to Analyze>Active Field Box>Change the name and; 3. Press Enter I also tried: 1. Click within the column where I want the header to be changed. 2. Right click>Value Field...

I hope someone can help with this issue. Using excel 2013 and I have a macro that triggers / synchronises several slicers that select the data in many pivots (approx. 4 per slicer). The macro then goes on and renders and publishes the report in PDF format. I have hidden all sheets except the...

Hi , I have a column of address . I want to sort out the complete and incomplete address Example - Complete address ends with 4 Digit Number as this Incomplete doesnt end with 4 digits <tbody> ZETLAND NSW 2017 true YOUNG NSW 2594 true YEPPOON QLD 4703 true WOOROLOO WA 6558 true 1...