dec

I have 3 cells in excel in same column. One has value "Dec, 2014", second one has value "NA_Dec'14" and the third one has value "NA_". As you can see 3 cells have 3 different values. I am looking to extract a date either first day of the month or last day of the month from the second cell which...

Hi How can I merge 2 formulas in 1 =average(offset(au4,,count(au4:br4)-bs2,,bs2)) =averageif(au4:br4,">0",au4:br4) AU3 to BR3 = Jan to Dec 2018 - 2019 BS2 3 which is month 3

I have a table im trying to do two things in. I am intending the user to enter parameters into the following cells Q32 - selects rank Q33 - user enters a date From that I need the following to happen: 1. Enter into cell Q35, the year of the next applicable board 2. highlight the row in the...

Hi! I have a VBA question. I have a bar graph showing the the number of sales every month for the last 5 months. For example: 1000 in Oct, 1200 in Nov, 1300 in Dec, 950 in Jan, and 800 in Feb The Months are in One row (Row A), the number of sales are in another row (Row B). Next month, I...

Hi I'm having trouble returning the correct values in the 2 cells shaded red in the below sheet. My objective is to show the ongoing corresponding number of miles cycled up to the same date in the previous year. The correct value for the current YTD total is the sum of cells C64:C93, which is...

Hi all, I have a situation where I need to do SUMIFS + SUMIFS + SUMIFS to get the desired result. For example, in the table below I am trying to populate the third column - essentially trying to add the data for client A123 + client B123 + client C123 for Dec 1,2018 in cell c1. Similarly...

Hi Guys, The sheet shown below tracks spend by calendar years and we need to change it to spend by tax/fiscal years April to March. Does anyone know how to do this ? Thanks <tbody> Supplier 1 MONTH Apr-17 £59.00 May-17 £60.00...

Hello I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry...

Hi, I have the following range in each cell: ='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2017 Daily Report\Daily Report\[Alor Setar.xls]Jan'!D4 I need to change the range to as follows: ='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2018 Daily...

I have created a excel chart and I want it to show perecentage completion upward trend but as of November is it 33% complete and the line drops to zero and from Dec data is not available I have selected the range from Oct 18 to Sept 19 and as blank cells it goes to zero. Is there a way to have...

Hello Genius, Kindly help me on the below requirement. Actually I have data in the format of "General" which has Date & Time in that. I need to convert it to Date format. From : Dec 5 2018 2:46PM to : 12/05/18 or 12/05/2018. Your help is greatly appreciated ! Thanks.

How do I compose a formula that looks at values in column BP that are from the previous week (The week always starts on a Monday. So for today,(being 4 December) I want it to count anything from Monday 26 November to Sunday 2 December inclusive please. On a Monday it needs to automatically...

Hi, I have a table that is a1:a13 Jan - Dec, then below each month are values, I want to add a column for each row to show the value for the previous month from today, so if its October today then return each value for September, then I can create a chart based on the previous month when...

trying to come up with a formula that takes avrg Jan Purchase Price Less December price * Qty of JAN. my obstacle is that if there is no Dec price, to have the formula pick up Nov price. If no NOV price, then the last month and so forth... then I'll have the same for FEB price LESS dec price...

This is what my spreadsheet looks like right now <colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4295;" span="4"> <tbody> CELL K EMAIL DEPLOYMENT phase 1 if eff date is on weekend, forward to next bus day (no holidays accounted for)...

I'm learning how to use the power pivot - which is an extraordinary improvement on normal pivottables. But I don't know the full capabilities. My challenge is this: I have data arranged as follows (the real data is more complex): <tbody> Activity Start Date End Date Total Effort A 1 Jan...

Hi, Below is my main data table of all my players: Sheet 1 <tbody> Name Total Rat. Cor Cro Dri Fin Fir Fre Hea Lon L Th Mar Pas Pen Tck Tec Agg Ant Bra Cmp Cnt Dec Det Fla Ldr OtB Pos Tea Vis Wor Acc Agi Bal Jum Nat Pac Sta Str James Coppinger 403 10 14 15 12 14 11 4 7 1 8 14 10 10 15 7 13...

Hi, I have the following format of data: a) 02/12/2018 0:00 b) 02/06/2018 12:00:00 AM 1) When I try to convert to month using =text(b1,"mmm"), it returns as Dec for set (a) and 02/06/2018 12:00:00 AM for set(b). As for set (a), the correct month is actually Feb and not Dec 2) As for set...

Dear I have a question to you. Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn. But now I want to use two parameters for one of columns. Simple example below Month Turnover ……. Jan 1 Feb 2 March 3...

Hello. I created a vba for my coworkers in Excel 2016. When users in 2013 run the code, they keep getting a runtime 5 error. Any suggestions? I tried various solutions on this board but can't seem to get it to work. Is it the "DefaultVersion:=6" that is creating the problem...