Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LaurieOZ

    Advanced CountIF Formula Help

    Hi socomfort Try the following =SUMPRODUCT(0+(MONTH(Sheet1!$A:$A)=MONTH(Sheet2!B7))) Regards Laurie
  2. LaurieOZ

    remove street address from address

    Hi Althea The main problem as already mentioned is the varying number of words making up the Street and the town-state-zipcode. My approach for a similar problem was this. 1 On a COPY of the worksheet Insert new column A,do a fill series 1...40000 make header "Index" . This will allow you...
  3. LaurieOZ

    Excel Help , formula

    Hi bilbonvidia I have created a formula using sumproduct function will make the goal seek easier Gross Pay 409.44 band 10500 201.9230769 Taxcode 885 170.1923077 Sum of 201.92+170.19 372.1153846 Tax & NI 57.85 Net 351.59 Tax Table Inc Level Tax...
  4. LaurieOZ

    Excel Formula Help

    Hi wjmcgreevey: You have introduced column "U" and a "score" category. Without knowing how they were constructed we can't tell. In each of Zathras,Rofeo, and Yogi's formulas the assumption is your data starts in A1 and you want every 5th number to sum The "ROW-Mod" formula is directly related...
  5. LaurieOZ

    Excel Formula Help

    Hi Roel Zathras's formula will work, however over a large spreadsheet the array formula will be less efficient than yours. As wjmcgreevy data started at T5 (the 5th row)the Mod function needs to be adjusted as mentioned in earlier post and the "5" changed to 14 representing the "Nth" row to...
  6. LaurieOZ

    Excel Formula Help

    As your data starts at row 5 (T5)then Zathras formula would need to be modified to adj the MOD-ROW reference as below Also note the change to sum the 14 instead of 5th row =SUMPRODUCT(T5:T6000,IF(MOD(ROW(T5:T6000)-4,14),0,1)) Remember Ctrl+Shift+Enter Laurie

Part and Inventory Search

Back
Top