included

  1. A

    Need To Get Elapsed Time Between 2 Dates During Working Hours ( All Days 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
  2. O

    Need help - cant figure out the right formula

    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...
  3. 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?
  4. K

    Question on Solver

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

    Cross reference cell values then copy data between sheets

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

    No idea how to title...Sorting in Excel to include group header?

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

    RE: Creating a Toggle/Command Button with a Text and Picture underlayer?

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

    Ranking values in Excel

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

    Structure chart with Userform - Link little connectors by a larger and single connector

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

    Conditional Formatting

    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)
  11. R

    Grouping Projects Formula

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

    remove Tab (char (9)) in Power query

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

    Formula has stopped working

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

    Row Data Change entirely

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

    Application.WorksheetFunction.SumIf: a range as a criteria

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

    Object Defined Error

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

    VBA code to switch back and forth between 3 different workbooks

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

    Matrix Table and Array Formula

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

    Averageifs comparing to other Multiple Averageifs formulas already completed

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

    Macro combination of cells already included in range

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

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
Back
Top