jan

I have racked my brain with a solution for this problem and can never seem to crack it. I have to calculate Cost Per Head (CPH) for several different slices of a data set consisting of >500k rows. This is simplified, but suppose my data has a column for Month, Team, State, Account, Account Type...

Hi Everyone, I have a table of two columns, one column for dates and the other column with duplicates items. I was wondering if there is a macro to arrange the 1st column by dates, and the second column with no consecutive duplicates (i.e. as much as possible as sometimes there is no way to...

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'm way out of my depth and and not even sure if a macro like this is reasonable (I'm sure it's possible, it just may be more effort than it's worth). I have a series of days in column "A" (starting in row 3), 1, 4, 7, 3, 5, 22, 4, 8, 30, etc. The numbers are the day of the month. In Column...

Hi, Please can you help with resolving a formula query that I have. I currently have the following formula =SUMIF(BF:BF, $C$3) R:R has various values in. BF:BF is a column with dates in. C3 is 01/01/19 formatted as Jan 19. I can get the total to work if the date in BF says 01/01/19 as it...

I have Folder name 2019, inside that I have subfolders in the name of months like "01-2019, 02-2019" so on.... in that I have further subfolders named as date like 01-01 for 1st jan, 02-01 for 2nd jan, 03-01…. and so on and inside each folder there is a excel sheet with name 'Excel Report'...

<tbody> Data Filter selection Jan Jan NowJanuary Feb RatJan Febby NowFeb </tbody> Hi Want to use Advanced filter whereby it filters using part supplied selection entered in the same sheet finding & filtering to all data that include this partial data Based on...

Hi Experts, I want to get specific text from the Column A to B like follows, please help with formula <tbody> SPVAR JAN 19 SPVAR IFG JAN 19 IFG R1 Adjustment JAN 19 R1 Adjustment Stock Adjustment JAN 19 Stock Adjustment IFG FEB 19 IFG SPVAR FEB 19 SPVAR Stock Adjustment FEB 19...

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, Please can you help with resolving a formula query that I have. Cell AK2 is 01/01/19 (showing as Jan 2019 due to formatting) Cell H227 I have 25/01/19 Cell L227 I have =IF(H227=0,"",H227) which shows as Jan 2019 again due to formatting. Cell S227 has £20.00. I would like my formula to...

Hi all, Within my Family Tree I work out the exact age of an individual using the following formula, E19 is date of birth and E20 is date of death. =DATEDIF(E19,E20,"y") & " years, " & DATEDIF(E19,E20,"ym") & " months, " & DATEDIF(E19,E20,"md") & " days" I have just come across a problem with...

Hello. I need some help with displaying my pivot table values as a % of the row total but nothing is working. I have a pivot that looks like this <tbody> Row Labels On Time Delivery Late Delivery 2019 Jan 142 48 Feb 216 196 Mar 439 92 </tbody> I cannot workout how to change the...

So I have my formulas set up. I would like to include multiple months of data in multiple tables in different sheets (1 month of tables per sheet) and have the information counted on an Audit Total sheet Sheet1 = Jan, Sheet2 = Feb, Sheet3 = March. So I want to reference sheet 1 in January and...

So I have my formulas set up. I would like to include multiple months of data in multiple tables in different sheets (1 month of tables per sheet) and have the information counted on an Audit Total sheet Sheet1 = Jan, Sheet2 = Feb, Sheet3 = March. So I want to reference sheet 1 in January and...

Hi all, I would like to “SUM” all figures from col. “C” to “O” in one row if in column “B” contains the word Unspecified using a VBA code. Therefore that the rows are not stably but rows 1 to 5 are the headings. I present below the original data and the expected result. Thank you all in advance...

Hi peeps. Can i ask for your assistance again. i need a formula for sheet 2 to extract info from sheet 1. In sheet 1 of my workbook i have a annual leave planner. Dates run from column f5 to nf5. Several rows below are the stats running from f20 to nf20. If the stat is higher than 3...

Hi Experts. I have data in sheet1 <tbody> AREA SKU JAN Feb Mar .. A 1001 10 50 10 B 1001 20 40 20 C 1002 30 30 30 A 1004 40 20 40 B 1003 50 10 50 </tbody> Sheet 2 Summary <tbody> AREA MONTH SKU VALUE A Jan 1001 10 </tbody> I need formula in cell D1 for SKU 1001...

Please help I need formula to bring result in cell A4 based on the change condition in A1, A2 & A3 from the array B1:F10. <colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody> A Area Source Jan Feb Mar Jan A Imp #FFFF00[/URL] , align: right"]1 2...

Wonder if anyone can help me. I am wanting to create a league table based on peoples sales. I am planning on separating the sales team into two worksheets. one for used one for new. the format below is what i will have on each worksheet. what i want to do is then create a separate worksheet with...

Hello everyone, Pretty much new here and in VBA. I am working on a internship project that just consumes too much of my time (please dont think I am trying to escape the task which I don't I am just looking for a better and efficient way of doing this monthly routine). On a monthly basis I get...