including

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

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

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?

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

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

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

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

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

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

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

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

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

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