1/1/2019

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

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

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

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

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

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

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

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

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

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

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

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

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

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