subscription

  1. N

    Sumproduct and if statement

    Is it possible to use sumproduct and if statements together, or is there an easier way of achieving what I need to do here? I have the following formula: =SUMPRODUCT(--(Statement!$J$1:$J$1724=C13),Statement!$L$1:$L$1724) What this does is look at my bank statement sheet for a particular line...
  2. S

    separating 2 dates from a same cell into 2 different cells

    Hi All, Please find the below descriptions which are 3 different cells (A1,A2,A3) Now i need to separate the dates which are highlighted below in BOLD into 2 different cells(B1 and C1) NOTE: All date format are in different format like (mm/dd/yyyy, mm-yyyy, mm-dd-yyyy etc) and also there was no...
  3. J

    VERY Long Loop - Looping across "call" function?

    Hi all, Hoping for some assistance here. Attempting to create a macro which takes data from several points on one line and populates a different spreadsheet with the relevant data, then goes to the next line and repeats. I've managed to get it working as intended, the only problem being...
  4. I

    formula understanding and improving

    Hi Guys hope all is well i have the below table at work with data and forumla, and i need help understanding 1) what the formula are doing 2) if i can improve these formula ( is there a more efficient way to do this. <tbody> A B C D E F G H I J K 1 NAME START DATE END DATE TOTAL LENGTH...
  5. G

    setting a variable

    Hi I have the following: Dim mySUN As Workbook Set mySUN = Workbooks("c:\SUN\Get_Sun - 2018.xlsm") I receive an error -->subscription out of range I would like to correct this. Thanks!
  6. M

    Formula for calculating Annually reoccuring subscription costs over a period of years

    Hello, New member to the website! I have attempted several searches for answers to the request and it looks like none of the threads have an answer to my question. I am looking for a formula to determine what the total cost of a subscription would be over a given period of years if the...
  7. T

    Formula to allocate amounts by month

    I have the following sales data for 2016, 2017, and 2018: <tbody> Column A Column B <strike></strike> Column C Column D <strike></strike> Column E Column F <strike></strike> Column G Column H <strike></strike> Column I Column X Row 1 Opportunity Name Opportunity Close Date (US date)...
  8. O

    insert Textbox value in Certain row

    Hello everyone, I have a table that the first column is the column of a subscription number and all other columns are currently empty, I have defined that if I double click on one subscriber number, a form will open Then fill in all the data of the same subscription number (eg first name...
  9. C

    Excel in Click to Run or Subsciption 365

    Anyone help with my confusion... I have Excel 2016 ( office 16 ) installed and I also just bought Office 365 but it was a "click to run" version as I found out. I'm really wanting the new insert icon features and have seen some info on Google that you only get this with a subscription package...
  10. J

    Subscription Recovered

    Hi I am trying to work out if a subscription has recovered during a period. I have three tables, date, subscription and customers. If a subscription churns (does not renew) at the end of the subscription period however within a 12 month period returns (from the end date of the subscription)...
  11. J

    Customer Subscription Amounts

    Hi I am trying to work out if a subscription value has done one of the following: No change - no change from current month to previous month New business - did not have a subscription the previous month and current month has a subscription Upsell - current month subscription is higher than...
  12. R

    Combining data from multiple sheets and group them

    Hi Guys! I have a problem which I hope one of you can solve! I think it will be a tough one. I have an Excel with multiple tabs of users in subscriptions. Each tab contains different information about the users (account permissions, normal permissions and settings). I need to group the users...
  13. E

    Add percentage column in Pivot Table

    Hello All, I am not able to add a percentage column in a pivot table. My data looks like this: Name Location Call Date Subscription Date State Country John Hackensack 4/4/2017 4/29/2017 NJ USA Peter Fort Colins 4/7/2017...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top