arm

Hello, Using Excel O365. Have created a pivot table and added subtotals as below. I want the subtotal on the MOQ field (and others not showing in the sample below) but I don't want the subtotal on the selling price, cost, margin fields as they are nonsense fields. How (if you can) switch of...

Hi, Please can somebody help? The purpose is to get the Max of column C for each AssetID(column B) and then return whether it’s a Cross Arm or Pole but I’d need to returnall values for Poles and Cross Arm if the highest occurs more than once per AssetID. So just for the below example, the...

This is the formula I am using: =IF(SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left...

Hello Excel Experts, I want to lookup the values in decreasing order from column A then lookup the data from Column B with matching with decreasing ordered value at Column F. i. e as follows <colgroup><col><col span="4"><col><col></colgroup><tbody> A B C D E F 1 marks name...

Hi folks I have a workbook I'm trying to tweak. I have a number of form control buttons running macros on the title bar of the sheet simplifying a few very basic tasks just sorting or filtering based on single criteria only... all works fine, been using it for weeks now....until I try and add an...

Hey all, trying to display a range of ounces for various laundry detergent but my formula has broke. Anyone see where im going wrong here? I'd like to have it display like this: 45 - 50 oz in cell F21.Thanks in advance... =IFERROR(IF(MIN(IF(B:B=B17,IF(A:A=" ",G:G)))=MAX(IF(B:B=B17,IF(A:A="...

Is there a way with Excel to calculate the APR for an adjustbale rate loan? I'm trying to figure out how to calculate the APR for an ARM loan that has a rate set for three years (initial rate) then the rate adjusts to the index plus the margin (2.75+1.25=4.00%) for the remainiing 27 years...