1/1/2019

  1. T

    Formula to sum based on multiple criteria -For subscription revenues

    Hello Excel Community, I was wondering if any of the amazing Excel masterminds can help me with a fomula based on several criteria. First I have a table with date which includes a customer ID, Customer Name, Type of Purchase, Date of Purchase, Start Date and End Dates of Purchase, the amount...
  2. K

    help with vba code to match data on multiple worksheets

    I need help with VBA code that will complete the following tasks: 1. On my “Leases” worksheet find all rows with the word “Yes” in the IN_DEFAULT column (column F) and copy those rows A through J. example "leases" worksheet <tbody> FILE_TYPE FILE_NUMBER CASE_TYPE SUB_TYPE OPR IN_DEFAULT STATUS...
  3. N

    Is it possible to dynamically update an Excel Table and have the master report shrink and grow?

    My goal is to update information in a master report whereby adding information to Excel Tables on other worksheets and have the master report automatically shrink or grow the area required as the data between sections can change? I've looked into several ways to attempt this however in Excel...
  4. M

    Data Range Formula to Calculate Number of Months in Current Quarter

    Hi Everyone, I'm having a brain fart. Can anyone help me with this? It will be greatly appreciated. My data has these two date columns and I need to figure out how many months fall in Q2 of 2019. The 3rd column shows the desired results it should give me using the 6/30/2019 date (For Q1, I'd...
  5. R

    using a macro to change the date of a Datepicker

    I have a worksheet that when a user completes they click on a button and the data is copied, pasted, and all the fields reset to blank except the DatePicker is there something I can do to call the DatePicker to reset itself back to 1/1/2019? I've been looking all over and I have found examples...
  6. S

    Horizontal sum with multiple criteria

    I've been driving myself crazy this morning trying to make this work, but I know someone here can point me in the right direction. I have some premiums collected sorted by month received on the horizontal axis and three breakdowns for the premium in column D. I would like to sum these for each...
  7. K

    Count duplicates across 3 columns, ignore unique (apply to entire column)

    Hello, I am looking for some help with a way to create a formula that looks at three columns if there are duplicates that are common across all three columns to count them, but if there are no duplicates found I do not want a count. If possible I would like to do this for the entire column...
  8. D

    sumproduct and index match help

    So here is what I am looking to do I have a column of dates then a calculated number 1 2 or 3 I have test data and results, I want to calculate the total for the year with an equation but I need the test date to be the latest one so here, 2/10/18 uses 3 then 6/2/18 uses 8 Equation is like this...
  9. B

    Formula based on multiple criteria?

    I need help with a formula to return fee amounts based on the account number and start date. In my example I need the fees and market values for all three months for each account. Please help! <tbody> ACCOUNT # 11/1/2018 FEE 11/1/2018 MARKET VALUE 12/1/2018 FEE 12/1/2018 MARKET VALUE...
  10. JTL9161

    Selecting Rows based on data

    I have a spreadsheet where the data in column "D" today's date -1 (yesterday) and column 'J" has dates 1/1/19, 2/1/19, 3/1/19..etc. I need to add to the bottom of my current macro something that finds the first cell with yesterday's date in column "D" and with 1/1/19 in column "J" and select...
  11. S

    VLOOKUP with multiple data sets/outputs

    Good morning. I don't even really know if VLOOKUP is the formula I need but here's what I'm trying to do. On sheet 1 I have a list of names in column A. In columns B through T I have a list of training courses. Something like this: <tbody> Course 1 Course 2 Course...
  12. M

    compare and color code

    I just want to compare the number in report A column G to numbers in report B row 7 and use a color code when the numbers do not match. What is the best function to do this without opening the tow reports at the same time all the times. Thank you for your help and time! Report A <tbody>...
  13. M

    compare for equal numbers and color code

    I just want to compare two different reports total to check if the numbers in bold matches. For report A, the January 1 total number 800 is not correct comparing to report B. Because 200 item are not recorded so I wan to flag that with color or other best ways. The same with May 1 records. I...
  14. SharmaAntriksh

    Extract data from an array and populate new array but only keep certain columns

    <tbody> Name Serial Number Date Price Address Comments A 1 1/1/2019 123 abc xyz B 2 1/1/2019 123 abc xyz A 3 1/1/2019 123 abc xyz C 4 1/1/2019 123 abc xyz </tbody> i have data that looks like this, i am trying to load this into an array and populate a new array with the data...

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