1/1/2018

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

Hey all! I am processing data downloaded from a Bloomberg terminal for over 8000 firms, but I am experiencing difficulty. The data set is in the current format: <tbody> AAPL BAC 1/1/2018 0.0430 -0.0131 1/2/2018 4.6958 0.1438 1/3/2018 0.8888 -0.1045 1/4/2018 1.0708 -0.4836 1/5/2018...

I have 3 equations i have tried, i am trying to do an index match with month and year but they are all returning #N/A =INDEX('Operating Modes'!C6:O150,match(month(B7)='Operating Modes'!B54:B150)*(year('semi annual'!C3)='Operating Modes'!A54:A150),MATCH('semi annual'!C4,'Operating...

Hi all, I have several worksheets containing data that I would like to exploit, example columns setup as per below. Worksheet 1 URN LLDRG Date1 111 apple 1/1/2018 123 pear 1/1/2018 222 apple 1/1/2018 Worksheet 2 URN Date2 111 4/2/2018 111 12/2/2018 111...

Hello. I have a query where I am doing Totals to get the Max date. The table has dates of 1/1/2018, 4/1/2018, 7/1/2018, and 10/1/2018. Each date may or may not have a different price for any item. When I do MAX in the date Total row I get 1/1/2018 AND 10/1/2018. Not just 10/1/2018. Price is...

I need to get a count of cases associated with vendors, grouped by month over a time between two dates. The month part is where I have trouble. I don't know how to make the query "count" each case number by vendor for each month. Ideally what I would get is something like Vendor Month...

Can anyone point me in the right direction to create a bubble chart out of the data below that shows each product as the same color, the date along the x-axis, the affinity index on the y-axis, and the avg basket $ as the bubble size? I've been searching, but can't find an example of what I'm...

Hi All, <colgroup><col width="58" span="3" style="width:43pt"> </colgroup><tbody> Date Month Value 1/1/2018 Jan 2 2/1/2018 Jan 4 3/1/2018 Jan 8 1/1/2018 Jan 1 2/1/2018 Jan 3 3/1/2018 Jan 5 1/1/2018 Jan 7...

Hi All, I am currently trying to write a code with SUMIFS formula but I'm having difficulty as I'm still a newbie at VBA. I tried using other codes from different forums including here but to no avail. Would also like to know if the code can loop for all blank cells in case other criteria...

Hey all, Ive found some code on a forum elsewhere and tried to retrofit it solve a problem im facing with formatting. I need to insert a certain amount of blank rows based on a value. I.E: If the value is 3, i need to insert 3 blank rows below this cell. The code ive found works nicely, but...

Hey guys, Sorry, pretty new to this stuff so hopefully i can accurately describe what im trying to achieve. I need to have 3 rows for each DAY/NIGHT to filter through to more functions. At times, i only have 1 value for this shift so will need to insert 2 new rows to make things balance. I...

Hello all, Is there a formula that will work for this? I want to type January 2018 into a cell (or two cells - Month/Year) and have another cell populate 1/1/2018. <tbody> Month Year Date January 2018 1/1/2018 </tbody> Thanks!

Hello I need to know how many agents worked on a call and for how long. The example below starts with column A and ends with F, rows 1 thru 6. The example is very simplified as there may be as many as 6 different agents helping on a call. Variables are, each time an agent logs into the call...

I am having trouble finding the 'split date' between 2 dates/times. My data does not export together, meaning I have a date field, time field, date field, time field. Example: From Date From Time To Date To Time so I used "=a1+b1" and the same for the next columns. Now...

Hi, I have 2-column data record (hourly data in 1 year = 8760 rows), for example: Column 1 Column 2 1/1/2018 00:00 15 1/1/2018 01:00 20 1/1/2018 02:00 5 . . . 31/12/2018 23:00 20 Then, I would like to summarize to monthly value. What I use is...

Hello anybody can help me solve a formula to check if the inv date fall between a promo allowance and if so get that promo allowance % and multiply by case, below is the data incentive table that im referring, I will like to bring the percentage...

I have a huge spreadsheet that updates monthly and I want to insert a column at the beginning for ease in reconciliation of the current balance and current AD. See example below...I basically want to update the date field on a monthly basis and get the current balances populated. Thinking this...

Good afternoon! I'm working on a formula for Column C to add days to the start date based on the type. Below is the formula I'm trying to use. It works perfectly when the type = "Testing", however, I'm not getting a "N/A" result when the type equals "Monitoring". Can someone take a look at...

Hello There! i am working on a project where i have been given 1200 files and all i have to do is to copy paste the data from 1200 file to 1 file under the given column headers(Headers are the same in 1200 files) i have already written a Macro to resolve this, it works fine in terms of copying...

Hi, I need to calculate the number of days when I have the start date but I do not have the end date (meaning the project is still open). I have two columns Start date = 1/1/2018 End date = blank I used =DATEDIF(A1,Today(),"d") but it does not account for cells that have End Dates in them...