march

I have a formula that uses an IFERROR, an INDEX and a MATCH formula at once. I want to change the output value of the MATCH so if a MATCH is found it outputs a 'YES' rather than the value that is being looked for. Formula is below; =IFERROR(INDEX('[Management Db...

Hi all, wonder if anyone can help. I have two columns; - E contains dates, in MM-YY format (i.e. 'Feb-19', 'Mar-18') - F contains text ('Same' and 'Changed'). I want to create a formula that counts the number of instances 'Same' or 'Changed' appears in a month. So far I have this: Looking...

Hi I have two identical tables, one on a sheet named March, another on a sheet named dashboard. I need to return the data from march into dashboard, simply by selecting a month from a dropdown list. I will have the same as march but for each month of the year, by selecting the month on...

Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...

Hello folks, I am looking for help to work with pre 1900 dates by adding days. As an example i have a date of 1 Jan 1788 and would like to add (x) days to it working toward 1 Jan 1900 in multiples of (x) days when Excel starts to work. 7 Feb 1788 plus (50 days) = 28 March 1788. 28 March...

Hello, this should be an easy one for you guys. Gmail is exporting timestamps to a googlesheet with the default Gmail format of: "March 16, 2018 at 11:41PM" Could someone please help me to convert this in an adjacent cell to just the time in military time? For example: "March 16, 2018 at...

The following table shows the date of the week and beneath each day is the hours that have been spent on a project, each row of numbers a new the project/job (not shown here). How can I get this into the table similarly setup to the right - with the same headings, using some sort of VBA...

Hi, Still very new in VBA, and came across what i could imagine is a very simple problem, with a simple solution. I need to filter the pivot table to show me the data between the previous thursday and next thursday. All my data is 1 day delayed, and therefor the use of: today()-1. so if today...

I've got the following set of conditional formatting rules: Problem with that is that for some weird reason, there are fields that aren't coloured: for instance, today is 6 March 2018 and the fields for 14 March 2018 aren't colour coded. I assume the reason is that date values don't just...

I am wondering if you can calculate an average over time? By this I mean if I wanted to know an average of a number at the end of each business day for a period of time but that average was from a set start date through the current day. Then, "tomorrow", it would add another day giving a new...

I would like to add weight of items which are delivered. That is if an item has along side a date then add that item to total else do not add that item. Please provide me formula. There will be 1000 + such rows and 10+ column . <tbody> Weight Date Weight Date Weight Date Weight Date Total 1...

Is there a way to modify this so that in March, it will transition automatically to April, April -> May and so forth? Sub NewMonth()' ' NewMonth Macro ' ' Keyboard Shortcut: Ctrl+Shift+S ' Sheets(2).Select Sheets(2).Copy Before:=Sheets(3) Sheets(3).Select Sheets(3).Name = "March...

Greetings! First post here at Mr. Excel I wanted to see if this could be done: I have a data set where I'm wanting to amortize an amount of a certain period of time. Let's say for a certain property, their implementation fee is $24000 and the implementation period/contract life is 24 months. I...

I want to search (with a formula) for a value and get the header of the column it exists (preferably without a "helper" column) <colgroup><col span="9"></colgroup><tbody> I have this table... A B C D E F G H I 1 January February March April May June July 2 1 X X X X A X X 3 2...

good evening all. I wonder if it is possible. I have a customer complaint sheet with a list of complaint reasons. I then fill in complaint with date, reason and various other info. at the top of the sheet I have the months of the year and I want to populate how many times during a given month...

Hi guys, Could you please help with any ideas with the below problem that I have? I would like to calculate in the column where it says "Variance" the difference between last column where it finds values and the column before it (April -March). I have added in cell G1 a dropdown list (bold)...

Hi there! Was wondering if anyone out there is able to share some guidance on my problem ahead.. I am hoping to create a dynamic calendar (that shows a daily view across different months of the year) to summarize the events happening daily. But this needs to be auto-fetched from a 2nd sheet in...

Hi, I have a pivot table like below <tbody> <tbody> 201509 </tbody> <tbody> 201517 </tbody> <tbody> 201527 </tbody> <tbody> 201540 </tbody> <tbody> 201544 </tbody> <tbody> 201546 </tbody> <tbody> 201548 </tbody> <tbody> 201550 </tbody> <tbody>...

Hey guys, I'm been stuck on this formula for a while, please help. The raw table below shows the fruit sale by month. Im trying to create a Month to Date formula that sums up the value of a specific fruit, based on the month selected. Specifically I can create a formula to sum Orange sale in...

Hello, my B2 is returning the value error if I look at Logical1 in the Formula Bar and press F9 I see #VALUE !,#VALUE !,10. If there anyway I can get B2 to return the 10 please? Excel WorkbookABC2Apples 1 March 1918 2 left#VALUE !10Sheet1