included

Hi I need to get the elapsed hours between 2 dates considering that working hours is from 8 AM To 4 PM all days included ( no week ends or holidays ) example : A1 : 11/11/2019 09:31 AM B1 : current time { now() } will be used

Hi, I'm having Excel issues and I'm stranded after multiple hours of googling. Question: How can I perform a VLOOKUP when the value is included in several rows (I want the highest number) Context: I have one overview where I wish list to various type of Information. This information have...

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?

I am trying to run the code below. When I run this, I am getting the following error message: OpenSolver Could not find an optimal solution, and reported: Infeasible The Model contains a restraint 'I2:I160 >=1' for which instance 4does not depend on the decision variable and is not satisfied...

This one is a bit difficult for me to explain, so i included screenshots to help....maybe I've have to cover some of the data as its personal information https://imgur.com/cFDqyS8 source<source <source (separate="" worksheet) https://imgur.com/jdC0Ii9 destination<destination<destination...

Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading? I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures...

RE: Creating a Toggle/Command Button with a Text and Picture underlayer? Hi There, we’re busy with an excel Invoice and want to create a toggle/command button with text and image upload ability. Below, please find the link to the file for ease of reference. I’ve also included an explanation...

I am working with a large data set. The values are included in two different columns. A lot of the values have very little value to the overall report impact. What I want to do is identify the top 10 items by percentages that have a number greater than 50 in my top 10 table separate from the...

Hi all, I'm trying to find the lines of code that would allow me to connect the little connectors of the row 5 to a larger one Here is how works the userform I've created The commandbutton1 allows to put the elements of the textboxes 1, 2 and 3 in the listbox 1 and 2. You can add as many...

Dear superusers, I would like to use conditional formatting with a formula to do the following: Color all cells red in SHEET 1, COLUMN A if it contains data which is NOT included in SHEET 2, COLUMN A. Thanks very much! Opgelost (The Netherlands)

Hello, I have two columns: Project - Include I want to group all of the different projects based on the order they appear/are marked included (1,2,3,n). How would I do this? Example: <tbody> Project1 X 1 Project1 - - Project1 X 1 Project2 - - Project3 x 2 Project3 x 2 </tbody>

Dear all, case there is another thread, I couldn't find it. So pls forgive me if I missed it. In Excel 2016 when getting data from a Table i am splitting a column by certain characters. But it turns out that in some rows there are tab's included which causes troubles. How could I replace these...

Current formula is =A1*B1 and in C1 is the total. A1 contains a number and B1 contains the word "included" but sometimes it is a number value and not text. I formatted column B as a number so the formula was calculating the word "included" as a number but now it has stopped and it's giving me...

Hi, can anybody tell me how to replace complete data in Row: like R10 data replace with R20 Data. Column A,B,C,.... included, if is it possible then partial. <colgroup><col><col><col><col><col></colgroup><tbody> Row10MD-ENVEOR262 9175752 07/06/2019 3 Row20MD-ENVEOR-L 9147254...

Hello everybody. I'm struggling with a variant of sumif. Below a classic example: Result = Application.WorksheetFunction.SumIf(Range("A:A"), Range("C1").Value, Range("B:B")) Now, suppose the criteria is not univocal. I mean: the criteria is not in C1, but has to correspond in one of the...

Hi Folks, I'm not sure why the following line of code fails... wsCustomerReportCard.Cells(10, LastRow(wsCustomerReportCard)).FormulaR1C1 = "=(8, LastRow(wsCustomerReportCard))-(9, LastRow(wsCustomerReportCard)" I'm simply trying to subtract with a last row reference as this included in a loop.

Hi, Wondering if anyone could help me with a problem I have with switching between 3 different open workbooks. The Workbook names never remain constant. 1st workbook ( Main Workbook that the code is ran from ) name will always change 2nd workbook , name will change but will always have...

Hi, I've been given a set of data which has a column of tariff names on the left, and a list of included service codes across the top row. Inside this table, there are letters (A,O,N), indicating whether a particular service is included in the tariff. I need to create an array formula that...

Hi there, I will try to make my question as simple as possible. I have a spreadsheet with lots of Averageifs formulas that are already working properly. Now All those Averageifs Formulas reflect multiple criteria that need to be met for each. My problem: I want to Average all the records that...

Hello, currently I'm working on a tool which will include some macros. I got several sheets with information about articles in columns A-D. All rows should be checked whether this combination of cells Ax-Dx is already included in range xy in sheet "result" or not. If not, the row should be...