feb

I have cells that i am trying to add.... A1 - FEB 16 - 60 B1 - FEB 17 - 45 C1 - Feb 18 - 120 The cell has a date, then a dash and then a number -I would like to be able to add the numbers after the dash. So for the 3 listed above it would sum 60+45+120 = 225... Thanks

Hi, I have month wise data Horizontally which I want to bring vertically with formula, please help. Horizontal...

Help needed! Data below shown John has 3 outlets in Jan. What would be the formula for me to put in C3 to get 3? If I change the manager to Smith, will the number change automatically as well? Thanks! <colgroup><col><col><col><col><col></colgroup><tbody> A B C D 1 Month Jan 2...

I am creating an on-time delivery report and this is the code for one of the steps in my process Sub NewDay()' ' NewDay Macro ' Button that initiates new day set up for on-time delivery reports ' ' Keyboard Shortcut: Ctrl+Shift+A ' Sheets("Feb 23, 2018").Select Sheets("Feb 23...

A B C D <colgroup><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col></colgroup><tbody> Issue Date Advertisement CMs Type </tbody> </tbody> 3 Feb 12 C 3 Feb...

Hi Guys, Please help me on below query. I need a vba code for below example. If there is an excel formula then that is also okay. Question: So if there are numbers on Row 3(see table below), I want it to return the text from Row 1. From below example. I want the code to return this. "Dec...

Hi there, I have a data set, obviously, and I need to scan through the dates to find the right months say feb. Once its found all the feb dates to then go across and count the amount of cells that have a time that's more than 48hrs. for turnaround purposes... this is how far ive got...

Hey everyone so here is what im trying to figure out. i have 100s of rows of data that i need to filter out if specific cells match each other so for example if A, B and C are the same as another other row with A, B and C i want them to highlight I tired some google searches and i just cant...

Hi all, Hopefully a fairly easy one. Months across the top A B C D M Jan Feb Mar etc Budget 1 £1 £3 £4 £5 So if I spend £1 in Jan, £3 in Feb and then £4 in Mar - how do I...

I'm not sure if this is even possible. I am wanting to check the current system date and than do the following. <tbody> A B C D 9 PP From To 10 3 7 Jan - 20 Jan 11 4 21 Jan - 3 Feb 12 5 4 Feb - 17 Mar 13 6 18 Feb - 31 Mar </tbody> Scan columns B and D to find where the current...

Hey evryone, I have question regarding following issue. My pivot table looks like this: <tbody> Month Asset Order Sub parcel for order Occupation of asset Occupation for one order Month sum Jan S2 A prod A 21:30h 21:30h ??? Jan S2 A prod B 21:30h 0 ??? Jan S2 B prod A 10:03h 10:03h...

I am looking for a moving total based on a criteria in my table from January through December depending on what month I choose. If I choose February I want it to give me Jan and Feb when I change to March, I want it to give me Jan, Feb, & Mar and so on. I have attached my example. sumif with...

I am using a MAXIFS formula to determin a MAX value based on date and day from antother sheet Problem is if there is no value on a date it will return 0. I need a formula that states IF the MAX returns 0, then it should just grab the number on the date above it. ex...

Hello all I am trying to use VBA to look at value "C4" on the active sheet Then copy this sheet 12 times and rename each sheet and based on "C4" as the 12 months from the value of "C4" on the active sheet IE Active sheet value in "C4" = Dec 17 Jan 18 Feb 18 Mar 18 and so on for 12 month but...

Hi, I have a table that I have created pivots for and need to now create a chart from the pivot. I am having an issue due to the way my table is formatted, hopefully someone can help. Ok, my original table is laid out in this way. <tbody> jan jan feb feb mar mar apr apr may may jun jun jul...

Here is my problem I have a user form contains a ListBox that been populated from column A. It's ok fixed that. I have 3 commandbuttons (TEMP, HUMIDITY,RAIN) and one PictureBox. I'm trying to create a graph that contains x axis= Jan, Feb, Mar, Apr, May, Jun and y-axis the values from cells...

Hello everyone! I have a little problem. I need a formula to show the last month for specific company. So for example for company xyz what is the last month that items were sold and then on for company abc. Between columns Month and Firm is also amount sold in original dataset. Does anyone have...

I would be a time saver if it is possible to use the content of a cell to link to a sheet. For example: I have a sheet named Jan, Feb, Mar, etc.. and a A1-A100 contains Jan, A101-A200 contains Feb, etc... In B1, instead of =Jan!B1, is there a way to make something like =(A1)!B1 work so I can...

Hi all, I have a folder with multiple sub folders that are all "# Jan", "# Feb" ect. and rather than change these manually I am looking to write a VBA script that will loop through each sub folder and rename them to "01 Jan", "02 Feb" ect. Any advice? Andy

My co-worker has a spreadsheet he uses to track employees returning from leaves of absence. We want to try and make it slightly more automated and so are wondering if we can have a Period Number appear in one cell based on the date that is in another cell. He gave me a list of what dates are...