jun-18

Hi i need a code to loop my data in column H in terms of month and year till its last row. so technically it should look like this Column H apr-18 may-18 jun-18 jul-18 aug-18 sep-18 oct-18 nov-18 dec-18 jan-19 feb-19 mar-19 apr-18 may-18 jun-18 jul-18 aug-18 sep-18 oct-18 nov-18 dec-18...

Hi all, I have the following, (a partial list). <colgroup><col></colgroup><tbody> 1220160070029210 0620180070029213 0120170070029213 1120160070029210 0420170070029213 </tbody> I need to first 6 digits as for example, Dec-16, Jun-18 etc. I can not use =LEFT(F4,6) There must be an...

I have multiple pivot tables (PT) in a workbook, which are all based on the same source data. Each pivot table is identical except for the unit acronym used in the Report Filter. I just noticed an issue with one of them, and have searched for a while now, without success. I'm certain one of you...

Hello everyone, I am coming across with coming up a formula to summarize the description. basically I would like to find the Serial number in column A. If it is other or reserve, then no further steps to be taken, other than that, I would like to find the respective payment type, period...

I have to populate the amount based on the value per month in the respective columns (Jan-18, Feb-18) based on the value 'Per Month' only for the duration provided (Start and End). <tbody> Start End Value Value Value Total Value Total Months Per Month Jan-18 Feb-18 Mar-18 Apr-18 May-18...

Hi, never had a problem until upgraded to Windows 10: I have a spreadsheet containing a column of dates in mmm-yy format. eg Jun-17 but when I enter Jun-17, Excel defaults to Jun-18. Same thing happens If I enter Jun-19, it just defaults to Jun-18. Can anyone Help? I am using Office 2013.