stephen

Hi, I have a user form with a number of pages within it. When I click on the tab to a different page, the userform scrolls so that the start of the page is right a the top. Is there any to make sure that it's scrolled to the top of the userform? Stephen.

Hi Why do I keep getting a #VALUE Error when I6 is "". It does have a formula in the cell but no actual value =IF(OR(I6=""),"",(K6+M6)/I6)/24 Thanks for any help Stephen

Hi I have one condition in below if "S" is found in B16 but would like to add PT so if "S" or "PT" is found then SUM if not leave cell blank =IF(ISERROR(SEARCH("S",$B16)),"",IF(SUM($BO16,$BF16,$AW16,$AN16,$AE16,$V16,$M16)=0,0,SUM($BO16,$BF16,$AW16,$AN16,$AE16,$V16,$M16))) Thanks for any help...

Hi If someone can help If the words "Part Time" or "Casual" is found in M17 then AZ17*Y17 but if "Salary" is found in M17 use the value in AZ17. Thanks for any assistance Stephen

Hi Just a quick question I have a simpe formula =GT274+GY272 but i want to return a "0" if GY272 =0, GT274 will have a value which will be either positive of negative. Thanks Stephen

Hi I assume I need a Count and/or Sum formula if the letter "S" is found in "I4" and also "A" is found in "F4" (both found not if/or) then use value found in "AP4" Any help would be great Stephen

Hi Maybe somebody can help. I would like a formula that sums cells T3, Q3, N3 if the text "PP" is or "C" is found in the cell "A3" (I.E 200PP or 155C) but if "S" is found in "A3" then the value 45 is populated. Thanks for any help Stephen

Hello, I have a few pivots all sorted by dates and regularly filter using the "this week" "last week" filters. Is it possible to create a slicer to do this? or something similar? Thanks Stephen

Hi I have assigned the following formatting (+0;-0.0;0) to display all minus values as -0.0 and all positive as +0.0 but my zero calculations are displaying as +0 which is upsetting my conditional formatting. Any tips for formatting type to display all Zero without the + sign in front Thanks Stephen