1. T

    Pivot table to exclude a row

    Hello, I have a table that looks like the following: Country Element AA 11 BB 22 CC 33 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...
  2. S

    Exclude a specific value from drop down list

    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...
  3. D

    Set Due Date/Time using DateAdd exclude weekend and holiday

    Hello, 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. Thanks Regards, Den
  4. A

    Resource Planning

    Hi, 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...
  5. muhammad susanto

    Average With Exclude Text,Blank Cell, Zero Number

    hi all.. how to make average formula exclude 3 criteria text, blank cell, zero (0) =IF(COUNT(H8:T8);AVERAGE(H8:T8);"") but still not fully working thanks in advance.. .sst
  6. J

    Average last 5 non-blank cells

    <tbody> 1 1 0 1 1 0 </tbody> Hello there, My goal is to get the 60.00% but what formula would I use to exclude blanks and only consider the bottom 5 values? Thanks!
  7. E

    VBA to Copy Range from Muliple Worksheets in one master

    Hi All, 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...
  8. P

    IF "x" is within all columns

    I'm looking for a formula to put in 100 rows to tell me if "exclude" is populated in any of the 250 columns. If yes, then "exclude included" If no, then "Exclude not included" Any ideas?
  9. A

    Dynamic Named Range exclude last row

    Hi all, I have a data set as follows: Data Headers A1: U1 Data: A2:U395 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...
  10. L

    adding text to two different cells and highlighting row

    Hello, 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: Sub CommercialMarketPlace() ActiveSheet.Select Dim a As Long For a = 1 To Cells(Rows.Count, "S").End(xlUp).Row If Range("S" &...
  11. C

    Skipping Specific Row Within a Loop

    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...
  12. C

    Graph exclude blank months at end of year

    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...
  13. R

    How to add a condition to COUNTIFS formula to exclude certain numbers?

    Hello, I have a COUNTIFS formula [=COUNTIFS(B2:I2,"<70")] that calculates the number of times a score is less than 70, as follows: <tbody> Dates 3/4/2019 3/11/2019 3/18/2019 3/25/2019 4/1/2019 4/8/2019 4/15/2019 etc. Student1 71 68 78 92 79 96 73 etc. Student2 56 71 68 75 70 81 77...
  14. T

    VBA dynamically exclude value in filter

    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...
  15. P

    Rank - exclude subtotals

    How do I setup a rank, type formula, to exclude subtotals? I am trying to pull a top 10 list. if I do a subtotal on the original data, I lose most of my top 10 values.
  16. G

    count cells that string contains X but does not contains Y or Z

    Hi, sooo..... 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. for the...
  17. R

    COUNTIF with exclusions

    Hello. I'd like to count a range of cells that contain any text using the formula: =COUNTIF(H11:H64, "*") 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...
  18. S

    SumProduct if A=ABC and to exclude B = 123

    hey guys, 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
  19. C

    vba autofilter multiple criteria same column not working

    So I am trying to use this to exclude two different choices in column 4 but it does not want to work, Any advice? .AutoFilter 4, "<>ETOX-SKIP, EDC/WDC", xlOr, "<>EDC/WDC" Of course this is just a snipit of the code but the part that does not seem to work, if i make it a single criteria it...
  20. R

    Exclude certain dates fron holidays in the NETWORKDAYS function

    I've set up a worksheet to calculate holidays. There is a table consisting two columns. On column with dates, which include and days-off (holiday, public holidays and business trips) and another column with types of holiday ("holiday", "Public Holiday" and "business trip"). I use this table for...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...