including

  1. S

    Remove duplicates (including original) based on a conditional?

    I need to find and remove all instances of duplicate values including the original, if any of the duplicates are status 1. I can't just find and delete all status 1 entries, because any names repeated that are at status 2 would need to be deleted as well. Would it be easier to search all status...
  2. S

    Adding to a New Collection

    Greetings, I am running into some issues while adding a new collection. The collection portion of my script is below: Dim col As New CollectionDim col2 As New Collection col.Add b col.Add c col.Add D col.Add E col.Add F col.Add G col.Add h col.Add i col.Add j col.Add k col.Add l col.Add m...
  3. J

    Max value including negatives

    I have a list with -.2, 0.5, 0.8, -0.9 I want a formula which can always take the maximum numerical value in this case -0.9?
  4. S

    SUMIF Multiple criteria - issue with Between dates

    Hi all, I'm using a SUMIF function where the first criteria is an item (fuel), the second, greater than 08/01/2018 and the third is less than 15/01/2018. If that returns zero, I have it referring to a another cell to produce an estimate of the cost I am trying to find. This issue is excel is...
  5. D

    How To List All Worksheet Names In Excel - Except a Specific Worksheet?

    Hi Folks, I have found this macro which lists all the worksheet names within a workbook. Sub SheetNames() For i =1To Sheets.Count Cells(i,1)= Sheets(i).Name Next i EndSub Let's say the worksheet I'm running this macro in is called 'Master' and there are 4 other worksheets in the workbook...
  6. M

    calculate business hours between two dates..including weekends And exclude holidays

    calculate business hours between two dates..including weekends And exclude holidays An assistant with be greatly appreciated
  7. M

    calculate business hours between two dates..including weekends

    calculate business hours between two dates..including weekends and exclude holidays
  8. S

    Using multiple IF functions in single formula?

    I've had a search and found lots of threads on this but not one that answers my problem. This isn't how my spreadsheet is but the quickest way I can explain what I need: A1-A4 - Are staff wages C1-C6 - Are separate expenses D1-D6 - Are each the same drop down list of staff names who need the...
  9. T

    Formula that considers two criteria

    I have a sheet that has a date column and a category and would like to add the totals for all the lines with the same category within a specified date range together. I'm using this below, but it's including items outside of this date range IF(AND('Check...
  10. K

    Mirroring Spreadsheets including color

    Hi All, I need to mirror two spreadsheets exactly including the colors. One thing I need to ensure is that new rows are also added to the second spreadsheet. Here is the formula I currently have, what am I missing...
  11. H

    Copy data from one workboiluding range names

    I would like to know if it is possible to copy data from one workbook to another including range names. If it is possible, please advise how to do so
  12. M

    update a table based on another table

    Hello, <o:p></o:p> I need a VBA for the following process please. Thanks. If we have 2 tables in excel. each table has diffrent number ofrows, they have 2 columns including car nembers and car names. the macrofirst look at the car number at table 1 then goes through table 2, if finds asame car...
  13. A

    Remove all characters before & including a dash

    Hi, My cell A4 contains the text 103-6807-2016-11-25 -CL- Joesep Byrne Senior -ST- Grace Jones.html I want to remove everything before & including the first - Also, other cells will have more than 3 characters before the 1st - taht I need to remove. Been trying this but can't get it to...

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