excluding

  1. G

    How to copy excluding one particular column

    Hi Everyone, Here i am trying to copy data from one sheet to another, where i need to exclude one particular column from copy sheet Like : Think i have 2 sheets( with names as "Combined","HSR") from HSR i need to copy all the data to Combined sheet excluding column "D" values...
  2. M

    Reverse date work days calculation

    I currently have a calculation that takes the start date, adds the duration of days and calculates the finish date excluding holidays and weekends. I would like it to do the opposite. Take the finish date, add the duration and back into the start date. excluding Holidays and weeds Any help would...
  3. G

    copy all the data excluding column 'D'

    Hi Everyone, i am trying to copy all the data from one sheet to another in same workbook. In master sheet i have A:AW columns of data were i should copy all the data excluding 'D' column, and paste that copied data in another sheet Can anyone help me how to solve this Thanks in advance
  4. Y

    Excel VBA Macro to Copy List but not Duplicate

    Hello, I have a worksheet with many sheets that i would like to summarize into one sheet. Essentially i want to go through ranges $D$29:$D$39 and copy the list ( which includes a column of cells with texts & values ) however there are duplicates so i don't want the same cell value/text to...
  5. K

    Exclude Overlap between date and time in excel and calculate Down Time

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I J K L M </thead><tbody> 2 SN. #B4C6E7[/URL] , align: center"]A #B4C6E7[/URL] , align: center"] DT #FFFF00[/URL] , align: center"]Actual DT...
  6. K

    Average formula to exclude outliers and zero

    Hi, I have a set of data that I would like to calculate the average excluding outliers (more than 800) and zeros. I am using the formula formula for excluding the outliers: =AVERAGEIF(C4:C21,"<"&800,C4:C21) Is there a way to modify to exclude zeros as well ? Appreciate all the help.
  7. P

    Mode excluding previous numbers

    Hello! In J2 I have Mode of Column B. In J3 I want to have mode of column B excluding numbers equal to J2. In J4 I want to have mode of column B excluding J2 and J3 and so forth. I was able to get J3 to work with =Mode(if(B$2:B$107<>J2, B$2,B$107)) That works perfect. I tried adding and and...
  8. K

    Using Conditional Formatting in Excel to highlight duplicates but excluding some

    How do you use Conditional formatting to highlight duplicates in a column of data but excluding (when highlighting) cells that contains "-" or ""?
  9. F

    Conditional formatting the minimum amount excluding blanks

    Hi all, I have been trying various formulas without success. I need to conditional format a range of cells, say A1 to G1 to highlight the minimum amount excluding any blanks in that range. I just can't do it and it's doing my head in! Any help is greatly appreciated. Fo
  10. B

    Summing top 5 marks in excel excluding those marked 'F'

    <tbody> Given below is the list of 6 marks with various grades. Now how can I sum top 5 marks excluding that marked "F" in excel? 51 B 45 C 63 B+ 46 C 52 B 59 F </tbody>
  11. A

    formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends

    formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends Any Help
  12. N

    Calculate no of days between dates, including weekends, excluding Holidays

    I need to calculate the number of days between two dates, including weekends but excluding holidays. I have a table listing the holiday dates named 'holidays'. Thanks
  13. C

    Sumifs excluding a range of reference values

    Hello, I'm trying to write a formula that excludes a set of values in sheet 1, in cells A1 through A5 I have Name 1, Name 2, Name 3, Name 4, Name 5. In sheet 2, in pivot table format I have hundreds of names in column A, in column B I have the corresponding revenue for each name, and in column...
  14. T

    Return values from column based on condition

    This is probably very simple but is giving me a problem. I want to retrieve values from column B of Sheet2 to column C of Sheet1 while excluding cells that contain certain text (up to 4 different text strings). Any suggestions would be gratefully appreciated. Best regards, truerip
  15. S

    time difference excluding weekend

    Hi, I have a huge data with date and time between 1activity and the other. I am searching for a formula to find out the "hour, Minutes and Seconds" difference excluding weekends(Saturday and Sunday) <tbody> 1st Activity 2nd Activity Time Difference 09-30-17 22:54 10-01-17 08:21 09-23-17...
  16. B

    Excluding specific file types from directory count

    Hi there, I'm trying to exclude specific file types when doing a count within folders in a specific directory. The code below works when the file is NAMED, but only when. I need some guidance on how wildcards would be used in a situation like this. In addition, I would GREATLY appreciate...
  17. G

    Time Spent Calculation : Excluding Business Hours

    Hi Community, I have searched throughout and found the formula to calculate time spent EXCLUDING NON BUSINESS HOURS AND WEEKENDS...
  18. N

    SMALL formula with negative values only and excluding 0

    Hi Guys, I have a the table below. I'm trying to get the smallest value with negative values only and excluding 0. If there are no negative values it should show a blank cell. I tried using OR and AND. It works with OR as long as there is a negative value. It doesn't work with AND. Thanks...
  19. H

    Unique Random numbers and Excluding old

    Hi guys, sorry if this is already answered somewhere i search alot and no luck finding it... I have the following issue. Lets assume i have a list in Column A (E.g. Names) and i would like to pick 3 members (never the same) of that list in the following Cells: B2 - C2- D2 Then in the...
  20. G

    Pivot table grouping issue

    Hello all, new user here, great community! :) I'm having a problem with a pivot table I created. Very quickly, I have this rows (those are days, number format) -3 -2 -1 0 1 2 3 I'd like to group them by 7 (a week), no problem with that; BUT I need to keep the 0 separated, something like...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top