# july

1. ### Countifs not referencing same cells and getting 0

I am trying to use CountIfs and every thread I come across all reference when someone is trying to reference the same cells for different criteria, which I understand why that does not work. What I am trying to do is reference three columns all for different data, but I am getting zeros...
2. ### Add month formula but without day or year

So I have a spreadsheet that I have a drop down for the month of the data, when I change this month then I want the cell in my next table to increase y 1 month. In other words if I select June on B2 then I want K2 to change to July. I have tried a few different formulas but I am failing. Here...
3. ### Using SUMPRODUCT with criteria

I'm using this formula to count the number of rows where the date falls in a specific month; I need to take it a step further - I now need to count only those in the month of July, (as above), but only if the corresponding value in column C is 'Not Available'. Anyone?
4. ### Calculation of incremental date on completion of 18 years

If joining date be between 2nd July to 31st December, the date of 18 years' increment will be 2nd July to 31st December after 18 years. But if the joining be between 1st January to 1st July, the date of 18 years' increment will be 1st July after 18 years. For Example, If A1 = 22/10/2000 as...
5. ### SumIf - Criteria in Column A but SUM Column F

A B C D E Date Expense Vendor Description Amount 6/6/19 Hotel...
6. ### SUMIF based upon worksheet name?

Hoping some of you can help. Say I have the following for example: Month: July Total 1 Bob 2 Jim 3 Josh 4 John Worksheet Names: July, June, May, April, etc. On each worksheet, say I have the order of names with the number codes next to them. How do I sumif based upon the...
7. ### Filter Spread sheet by date range and calculate difference between dates

Hi I have a large spread sheet that needs to be analysed at the end of each month. I need some help trying to make this much more efficient. Currently on hire dates are in a column (R) and off hire dates in the next (S). R S...
8. ### Macro to export last sheet to Desktop

I would like a macro to save my last sheet with the same name as the sheet for if sheet name is July 2019 to save as July 2019 followed by -BR1 Data This sheet to be saved will always be the last sheet tab Your assistance is most appreciated
9. ### Contents of row deleted based on a zero value

Please can someone help me with a script - I have a table 11 columns (D to N) and 7 Rows (Rows 7 to 13) - I would like the contents of each row removed if the value in G = 00:00 <tbody> Days Worked Start time Finish Time Time Worked Breaks Yes/No Breaks From Breaks To Total Breaks Total...
10. ### Help Needed for unique task

Good evening Ladies & Gentlemen I have been asked by a friend if I could help with an issue she faces on a weekly basis with excel workbooks Basically on the Monday morning of each week, she has to open a folder and view excel workbooks contained within that has around 80 - 150 workbooks at...
11. ### Help sorting rows with dates greater than 14 days prior

Hi, I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example <tbody> Invoice Number Current +30 +60 +90 +120 Total Debtor Name Invoice Date 123456 0 10 0 0 0 Invoice Date 123457 10 0 0 0 0 Invoice Date 123458 0 0 10 0 0...
12. ### Vlookup from external workbook

Hi All, Can someone help me with this formula below. i wish to extract a cell value from a different workbook. The workbook name stays the same, but the date changes everyday workbook Name is IBT PRINT LIST 22nd July 2019.xlsx =VLOOKUP(B8,'[IBT PRINT LIST 22nd July...
13. ### use conditional format to highlight current month

Hi I have in N79:N100 the last day of each month>>N79= June 30, 2019...N80=July31, 2019...N81=Aug 31, 2019...etc I can't figure out how to write a conditional format to highlight the current month Example: This being July, I want to Highlight N80 after July 31, I want to that cell to go back...
14. ### Conditional Format

I know this should be simple, but my head won't work this out! In Row 1 I have months In Column A I have dates of work started What I need is conditional format to "grey out" the cell if the date in column A is before the start date of the month So if the date was 02/04/19 it will leave the...
15. ### Countifs based on another tables components

I have two tables one of them contains a particular's distinct values as a primary key. and another table consists the same particular's multiple values for different dates along with few more details. now based on some conditions i want to bring the outcome count to the first table for further...
16. ### Automatically enter month in a cell

Morning, I use the same worksheet template every month. I would like to put a code etc in Cell B1 which would just enter the month. So say starting in July the cell is blank. I open the worksheet the code looks at the current month from pc etc and enters JULY into Cell B1 Next month i would...
17. ### Search for a specific template

Hello friends. I have a very important project that I work on. I will be grateful if you could help me. I need to group and search the data on Excel. Below you can see the schema of the data: Column A Column B Column C Column D Column E 1. X 1 July 2. Y 2 July 3...
18. ### Hide/Unhide Excel File/s.

Hey all, I have a stock management .xlsm files for each month of the year 2019 These are named as follows in the folder named = Stock Share 01. January, 2019 02. February, 2019 03. March, 2019 04. April, 2019 05. May, 2019 06. June, 2019 07. July, 2019 08. August, 2019 09. September, 2019 10...
19. ### wild card date

How do I use vba to refer to a sheet with a date of "july xxxx"? The x is in place of a number. Therefore, it could be july 2018 or july 2019 etc?
20. ### Formula based on date

Hi everyone i am trying to figure out a way to do the following formula: If(and(A1=“site 1”,or(C1=“monthly”,C1=“quarterly,C1=“yearly”)),B1,””) this formula works, however I Have a date column in D and what I need to achieve is that if C1 has “quarterly”, the date needs to also be within the...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...