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 Rhinorhino 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. BxWill

    MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF

    Current Nested IF statement to populate a Month by Year Grid on an MS Excel 2016 worksheet with the count of specific records that meet multiple critieria; =IF($D$6="All_Ranges",SUM(COUNTIFS([Zone],$D$4, [Grade_Range],{"< 20","20 - 29","30 -39","40-49","50-59","60-69"...
  2. BxWill

    Generating an OAuth Token - Steps using R

    Any insight as to the resolution of a status code of 401 using the R code below? Attempting to generate an oauth token. Thanks in advance. library(httr) base64_value <- "123456789=" response16 <- httr::POST (url = "https://api.precisely.com/oauth/token" ...
  3. BxWill

    Generating an OAuth Token - Steps using R

    Appreciate some timely insight! Novice - first time attempting to extract data via an API. I obtained a API Key and the Secret. Converted to base64. Now perplexed as to the next step where the instructions that I have state that I should "Enter the generated base64value in the header and...
  4. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Just had a thought - It is maybe best to just use four cell references or four dynamic range names within each formula instead of the hardcoded dates...
  5. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Did create formulae similar to the following; Sum up prior 6 months in 2021 (not including the current month) =SUMIFS($H$7:$H$186,$G$7:$G$186,"="&$P$11,$B$7:$B$186,"="&$P$10,$L$7:$L$186,">="&DATE(2020,12,1),$L$7:$L$186,"<="&DATE(2021,5,31)) Sum up the same 6 month period in 2020...
  6. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Thanks for the insight. Initial response is that the sumproduct formula for the prior year will still include "DATE(YEAR(TODAY())-1", right? If the Sumifs prior year formula is not currently working by using "DATE(YEAR(TODAY())-1", maybe there is another method to specify the prior year -...
  7. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Thinking this through, using the EDATE function may be the way to go due to maybe limitations with using Year(Today) and Month(Today). Other option is to just input the actual dates and move forward.
  8. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Continuing to review and did determine that the last row of data is on row 31, not row 30. However, the formula to display the prior years' sum is still not displaying the correct nummber of 33, not 26 as originally stated. Note, the last number should be "7", not "4." So, by including the...
  9. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Thanks for the time and insight. The second formula should work and the sum should be 26 not 59. I intentionally did not include the current month. In essence, a lag is applied. At any time during the current month, I want to review the past 6 months and compare to the same period the prior...
  10. BxWill

    MS Excel 2016 - Using Sumif for Year over Year Analysis - Not Working

    Using Sumif to dynamically sum the values in column C for a 6 month prior period for the current year, 2021. Formula is correct - the sum for the desired months is displayed...
  11. BxWill

    Windows not loading - PC Angel Recovery Displayed

    Timely insight needed! Have a HP Elite Book with Windows 7 Professional 64 Bit loaded and cannot log into windows for the past three days Ton of information on the laptop! Have attempted the following to no avail; Safe Mode Safe Mode with Command Prompt Enable Boot Logging Each time, I am...
  12. BxWill

    Percent Change between two estimates with margin of error

    Timely insight needed to create a formula to calculate the percent change between two estimates that also should consider the margin of error for each estimate. I am told that the estimates are for two non-overlapping time periods. The MS Excel 2016 worksheet include the following seven...
  13. BxWill

    Count the number of commas within a Non-Text field within Double Quotes

    I misspoke. The data is delimited but it was not parsed. After some thought, I decided to resolve the immediate objective from a different angle. I just compared the number of commas within each record with the number of colons. If there is a difference, then I know that there is a field...
  14. BxWill

    Count the number of commas within a Non-Text field within Double Quotes

    On a weekly basis, I receive over 2500 non-delimited records with the following format whereby all of the data is in column A. equip_type:"C","seller":"SampleSeller LLC","buyer":"SampleBuyerCorp","address":"1000 Main...
  15. BxWill

    MS Excel VBA - Create Hyperlink to Worksheets based on value in row

    Timely insight needed! I have a MS Excel workbook with more than 40 worksheets. The worksheet names correspond to the account numbers in column C on Sheet 1 beginning at row 10. Note, column C contains the formula "=MID(Trim(D10),1,6) For Example, In column C at row 10 are the following...
  16. BxWill

    Sumproduct Across Multiple Sheets with IFERROR

    I currently do not have any control on the design of the workbooks. Actually, there are over 25 worksheets! For this example, I indicated that there are 3 worksheets just to simplify. I will apply the logic accordingly to my actual case. Really think that this is a rather complex formula...
  17. BxWill

    Sumproduct Across Multiple Sheets with IFERROR

    ...following formula, I am able to extract the data onto the "Combined" worksheet from the "Widgets" worksheet. '=SUMPRODUCT((AccountNoWidgets=B3)*(ItemNoWidgets=C3)*(EstimateWidgets)) But, the latest formula does not work...
  18. BxWill

    MS Excel Convert Abbreviated Number to Long Form

    ...REPLACE function such as; =REPLACE(AC,1,1,"") Then, in the second helper column, column AE, I insert a formula such as =LEFT(AD2,LEN(AD2)-1 * IF(RIGHT(AD2)="K",1000,10000) This initially appeared to work but involved multiple steps. Any insight as to a VBA approach whereby I select...
  19. BxWill

    Sql Server - Create summary table using detail data in another table

    Well review in detail. Meant to imply that designating a composite primary key ("Equip Code" , "Mth", and "Sales Price Level") for this "new aggregated table" would appear to be preferable instead of setting up a incrementing ID field. Particularly, since I will add data on a monthly basis...
  20. BxWill

    Sql Server - Create summary table using detail data in another table

    Appreciate the insight. Vaguely familiar with CTEs. Will research further. It appears that then loading into a Sql Server table and using a composite primary key of "Equip Code" , "Mth", and "Sales Price Level" will enable the unique identification of each record rather than an arbitrary id...

Part and Inventory Search

Back
Top