sep

Hi Folks, Need help on the Pivot setting or option I can use to allow me show the percentage of TRUE on the column from each month see sample result below. RAW Worksheet <tbody> A B C D 1 DateM SLA Met 2 Sep TRUE 3 Sep TRUE 4 Sep TRUE 5 Sep TRUE 6 Sep FALSE 7...

I have the date in this format "Day: 11 Sep 19", just need date from this "Day: 11 Sep 19" in format as date format 11-09-2019 any idea.

Good day all, this is my first post here. I have a table of information that I edit each day, needing to have the newest information on the top of the list. I need to do a count of non-blank cells in column A, and as I append the list, I add a blank row at the top of the list. Well, I actually...

I have tired several ways to perform what (i think) should be easy. In Column A i have text that starts in the same manor but after 19 characters there is some info i want to use. Below is a sample the text in Bold is what i need to use A1 Greyhound Racing / CPark 25th Sep : D4 265m A2...

Hi folks, I need a formula column to aggregate the codes billed per customer visit (solution would look like E2:E10 below). Then later I can include the results in a PivotTable to see the combo frequency of codes billed at this store. There is a large list of customer transactions. Each row...

Hi, I have a date value 9/1/2019 in a cell that is formatted as MMM YYYY so it appears as Sep 2019. I would like the year to appear on a 2nd line in the same row. So instead of Sep 2019 It should be: Sep 2019 How can this be done? Seems wrap text doesn't work on dates. Thanks

I have a macro that populates a range of cells with the months horizontally, but am getting an error when I try to make it vertical. Horizontal: ActiveCell.Resize(, 12) = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec") Vertical: ActiveCell.Resize(12, )...

<tbody> 2018-08 1 Aug 18 31 Aug 18 2018-09 1 Sep 18 30 Sep 18 2018-10 1 Oct 18 31 Oct 18 </tbody> Please see table above. If I have a date like 9/15/18, I want it to run a search against this table, then return the corresponding result in col A, ie 2018-09. At the...

Hi All, I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it...

<tbody> Month Emp # Opening Casual Leave Availed Casual Leave Casual Leave Balance Sep 18 1 05 01 04 =(C1-D1) Sep 18 2 07 02 05 =(C2-D2) Oct 18 1 04 ? auto fill Oct 18 2 05 ? auto fill </tbody> how to opening casual leave auto fill while entering new month payroll?

Want to create VBA for each code to look for cells in i12:i50 and substitute the string Sep with Oct The string could for instance be: corp sep accrual which should be converted to corp oct accrual Sub journal() Dim describ As String describ = Range("i12:i50") for each describ if End Sub

Hi Gurus i am newbie in VBA and i have tried a lot by searching in google to create a script and finally end up here for help. need a help on this to copy the data from Master data to Multiple sheets based on the condition in excel for Sep 1 to Sep 30. copying the values based on the Rownum...

Hi All, Is there a way to provide an Input Box/Message Box to prompt the user, which macro/sub to run? For Example, If they want Sub Sep() to run they will input in the Input Box/Message Box. Many Thanks! Pinaceous

I want split/separate a text string into Text and Numbers Example: Hafnia Nordica S/B 49.999 59.100 2010 off Amsterdam 25. Sep UKC 25. Sep ums/nap/jet I want to split numbers and text into different columns. Please help

Hi Everyone, I have this data in Sheet1 - RECEIPT (1) NAME of payor, to be encoded every time clients pays for the service (2) DATE and TIME (3) AMOUNT (4) Receipt Number - should add an increment of 1, upon printing of receipt example, A...

I have a workbook with three sheets - Data, VisitDate1, and VisitDate2. VisitDate1 takes the date from "Data": =INDEX(Data!H3:R3,MATCH(TRUE,INDEX((Data!H3:R3<>0),0),0)). The result looks like this: <tbody> Mon, Sep 10, 2018 8:30AM - 2:00PM </tbody> VisitDate2 should take that date and...

Hi I'm trying to list the dates that represent the begining of each week of the year but, when a week has two months, I would like to split it. I do not want to use vba to do that, just a single formula. The bold+underline cell in the table below is the starting date. In the second line and...

I have a large spreadsheet of which two of the columns are : <colgroup><col><col></colgroup><tbody> Date Payable Month 22-Sep-16 Sep 27-Mar-17 Mar 22-Sep-17 Sep 07-Oct-16 Oct </tbody> The dates are in number format in col 1 In col 2 I would like the text value of...

Hello - I need help form excel experts I want to prepare a report in the following format. If I need Employees Report CPR Wise, it should be like this Month - CPR No - Payment Date - Amount jul - 01-07-17 - 31-07-17 - 300 Aug - 01-08-17 -31-08-17...

Hi there, i am looking for a formula to enter into cells (JAN-DEC) for each row that calculates a % increase and is tied to the effective month column. Is the only solution to do multiple IF statements for each cell? Any help is appreciated. Thanks. <tbody> Core Increase Eff. Month...