april

I hope someone can help me. I have a table in cells B2:m18. The column headers are months of the year starting with April. What I am trying to do, is populate a cell with some specific cell data from within the table base on two dropdown cells. For example if within sheet1 and within cell H4...

Hi there - I have a spreadsheet with a worksheet for each month containing various bits of information I am trying to set up a summary page that shows how often a term ('Smith', 'Jones', 'Johnson', etc) occurs in each month. I want to see how often a customer has contacted me each month and...

I'm trying to write a VBA script that will turn table A into Table B Table A: <tbody>#FAFAFA[/URL] "] #FAFAFA[/URL] "] Name Animal #FAFAFA[/URL] "] Mike Dog #FAFAFA[/URL] "] Mike Cat #FAFAFA[/URL] "] Mike Mouse #FAFAFA[/URL] "] Mike Rat #FAFAFA[/URL] "] Mike Chicken #FAFAFA[/URL] "]...

I tried searching for the answer, but the problem is that I don't even know how to phrase the question for a search. I receive a csv file with data broken out into different groups of rows and columns. I want to clean up all of the data into one table. I tried highlighting the examples below...

Really needing some assistance:- I have a workbook with multiple sheets but what I am wantingto do is have all columns of one sheet automatically populate onto anothersheet if a certain word shows up in one of the columns. For example: - If the word April shows up in column D I want all...

Hi everyone. I have been searching and searching, but could not find anything. I am using a form in Excel and in the date filed, I have a "pop up calendar." I created the form in April 2018. When I click the field, the calendar pops up. At the bottom, it says Today: 7/16/2018 like it...

Hi I need some help calculating a weighted sum. I have an example which shows how it should be done. Any help is great appreciated! Thanks in advance Sample Data: <tbody> A B C D E F G Total B 48% 5% 33% 14% 100% C 16% 2% 5% 9% 21% 23% 23% 100% F 13% 35% 30% 22% 100%...

Hi everyone, Here is the situation: -All Workbooks are located in the same folder -Each Workbook may or may not have the Worksheets "April " or "April 2018" -I want to copy all worksheets with file name "April " or "April 2018" in current Workbooks to new Workbook Please help me if you know...

Hi, I need a formula that will return one of F2019, F2018 or F2017 depending on the columns of year and month. Our year end is March so F2019 will run from April, 2018 to March, 2019; F2018 was April, 2017 to March, 2018; and F2017 was from April, 2016 to March 2017. I was trying to use...

Hi Posting for the 1st time in an excel forum as I cannot locate a solution to my day query in excel. I have a list of dates from 1st April 2015 to 31st March 2016, each date has a numeric value associated with it. I need to build a profile for 2018 from 1st Jan to 31st Dec, the issue is 1st...

Needing assistance with the following... Name Month Rank Time Order # Desired Result Bobby April 4 2:30 12433 0 Bobby April 0 4:30 14655 1 Bobby April 4 7:30 18654 0 Bobby April 2 3:30 98752 0 Bobby April 0 1:30 11548 1 Tommy April 0...

Hi I have the formula =VLOOKUP($A2,INDIRECT(""&$P$2&"!"&"A1:E170"),2,0) However, I want to name the tabs by date, ie 30 April 2018, 7 May 2018, 14 May 2018 etc. I then want to reference the date in P2 to match the sheet. I understand I need to use INDIRECT and the formula works if I input the...

Hello...I need some help with date-related formula: I signed a 3-month contract with a client in the amount of $300 effectrive from January 15 to April 15. I would like a formula that returns the revenue each month as follows: January: $50 (pro-rated since the contract started January 15)...

...based on a date that falls between two given dates. For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30. Thanks!

Hi Members, Kindly assist me, I am trying to find a formula to find the next specific month. Example I want to return the next 01 April from a date, ie. 24 Sep 2017 will return 01 April 2018. Thanks.

Hi i have analysed the data I have to produce a table showing the number of cases received and cleared each month based on converting the date field into months. I now have a problem because the 12 months has gone round and now I have April repeating itself so I need to add the year to the...

Hi, I have 19 sheets that all have a table like this: <tbody> Date Loan Balances Daily Interest 03/30/18 XXX.XXX Loan*rate 03/31/18 XXX.XXX2 Loan*rate </tbody> I would like to have all 19 sheets to automatically generate all the dates of the current month when such month arrive. For...

I am having issue trying to get header references working in a code I'm developing and I'm hoping someone can help! Instead of using column labels "A" , "B" etc is it possible to use Table header references as I'd like to move / insert columns into the table with more information without...

I think I need an INDEX MATCH formula here but I just can't figure it out. Sheet 1 <tbody> Payee (B) Amount (C) Date (D) 1 Payee 1 130.08 April 20, 2018 2 Payee 2 40.00 April 21, 2018 3 Payee 3 131.25 April 6, 2018 4 Payee 4 145.59 April 29, 2018 </tbody> ----- Sheet 2 <tbody>...

I have a month and year in A16 on sheet months I am trying to set up a formula that if the month in A16 < April then return 0 , otherwise return 1, but it retruns 1 =IF(TEXT(Months!A16,"MMM")<"Apr",0,1) It would be appreciated if someone could assist