Here’s my scenario:
I have a list of words and a list of letters.
I want to return the words that contain letters from the list of letters and ONLY from the list of letters. For example:
WORDS: cog, bib, ab, back, cab
LETTERS: A, B, C
WORDS returned: ab, cab
Hello, I have a table that looks like the following:
Now, I want to pivot that table to show me the sum of "Element", BUT Country "CC" has to be excluded from the sum (and shown separately in the same pivot table).
I created a calculated field defined...
I have a table where I have staff names. I use these staff name to create down down list using INDIRECT formula and it works perfectly.
Now I want to create a new drop down list, but want to exclude few specific staff name and show rest of the staff names.
I using below formula but I get an...
Need help, i use DateAdd function in my Query, DateAdd("d",numberofdays,StartDate), however i need to exclude the weekend and holidays. Can you guide me on how i can do that.
I've got a resource plan spreadsheet and its functioning fine, but i was wondering if anyone can suggest how i can get it to exclude weekends and holidays.
my forumula is: =SUMIFS(Table1[[Hours/Day]:[Hours/Day]],Table1[[Resource Name]:[Resource Name]],Report!$B17,Table1[[Start Date]:[Start...
I am hoping someone can help. I have a spread sheet with 30+ tabs and I want to copy certain named tabs for the same range on each selected tab into 1 master sheet. The below works if I have only 1 to exclude but I have multiple to exclude . how do I amend to either include 20+ sheets...
I have a data set as follows:
Data Headers A1: U1
The number of rows in the data changes every month, and so I have a dynamic named range I want to use (formula below) which exclude the last non-blank cell in the column. The problem is I need to apply it to the whole...
Can someone please help me with this? I am using a Dim statement in VBA but would like to expand my text to the next column over. Here's what I have so far:
Dim a As Long
For a = 1 To Cells(Rows.Count, "S").End(xlUp).Row
If Range("S" &...
Good day all,
I have a quick question: I am running a loop which copies certain cells from rows according to an IF statement from a different worksheet.
My code runs from i = 9 to i = 61 but I need it to ignore row 21, as it meets the IF condition yet I still want it to be ignored, how would I...
I have a graph of calls for each month. Jan to Dec Along the year, say in June, I'd have blanks for July to Dec.
I'd like the graph to only show months with data, ie Jan to Jun. and not include empty space for the last 6 months. I've searched and found how to exclude blank dates between...
I have a COUNTIFS formula [=COUNTIFS(B2:I2,"<70")] that calculates the number of times a score is less than 70, as follows:
I was wondering if anybody can tell me how to exclude a specific value from a filter after I run my macro. I have the code at the end so it runs last however I am needing to always exclude 0 and #N/A from the output. I cannot tell it what values to include because they change with every run of...
I have list in table 1 (below) and I want to count in table 2, the number times the text in table 2 column A appear in the list from table 1. BUT i need to to exclude any entries that are in A4 or A5 from table2.
I can do count if but i cant figure out how to exclude.
Hello. I'd like to count a range of cells that contain any text using the formula:
Problem is that it’s counting all of my cells since they each contain an IF statement. How do I exclude cells that contain an IF statement that output blank? For example, here’s what one...
would apreciate some help
What would be the formula, to do the following logic?
To sum the values in Column U, but only if Column A = B1(same data as the value in cell B1) and Column B= C1 but exclude if Column D= E1and Column E=F1
thanks in advance