engineering

  1. G

    Need help merging cels based on another cel

    All, I have been trying to figure out how to do this, but i have been unsuccessful so far. I have a spreadsheet (below is just a snippet) that contains the following information: <tbody> GROUP User Telecom-Corp User 1 Telecom-Corp User 2 Telecom-Corp User 3 Telecom-Corp User 4...
  2. J

    N^1.85 scale for fire protection hydraulic graphing on the X-axis

    Hello, I stumbled across the following thread, but just not following how to accomplish this: https://www.mrexcel.com/forum/excel-questions/104218-n1-85-graph.html Does anyone know of any other threads or have any examples they can share with me? Thanks!
  3. Welsh Mark3

    Common Words in Excel

    I have a list of about 8000 company names, I am trying to identify the keywords that appear in this list. Does anyone have any recommendations? For Example Mark Edwards Supply incRick Cook Supply America Engineering LLCAllentown Engineering
  4. A

    How To Use INDEX and MATCH with More Than One Lookup Criteria

    Hello Gurus. =INDEX(PartsListData!$K$1:$T$500,MATCH("CAA Engineering",PartsListData!$K$1:$K$500,0),10) using CTRL SHIFT ENTER works with one criteria How would I go about doing the same with the ability to check column K, and if "CAA Engineering" or "Technology Engineering" (key word being...
  5. T

    Selecting names from one workbook and placing them in another workbook.

    Hello experts, I am hoping that this is not too big an ask? I have a workbook called weekend planning, I was wondering if it would be possible that when I add a date into the cells highlighted then it will cross reference with my engineering rota workbook and workout who is on shift for that...
  6. U

    VBA Code to Copy a Sheet from Workbook A and paste it on that sheet in Workbook B

    Hello, I have a large workbook which does a ton of engineering calculations to select which parts to use in a construction product. One sheet in this workbook contains a list of parts, which I'd like to copy to another workbook which handles the pricing and ordering. Essentially, I want a...
  7. B

    Sum if one criteria over multiple cells

    Hey everyone! I have a data set that I would like to summarize - and no I can not use a data table or pivot chart for what I am doing. I have 4 types of cost classifications - Internal Engineering, Internal Testing, External Engineering, and External Testing I need to have an equation that...
  8. J

    VLookup with Zeros

    <tbody> 99-111 TECHNICAL REPORT: $0 $0.00 99-112 ENGINEERING: $0 $0.00 99-113 PATCH ENGINEERING: $150 $1.00 99-114 LAND ENGINEERING: $0 $0.00 99-115 ELEC ENGINEERING: $300 $1.30 99-116 MECH ENGINEERING: $25 $3.30 </tbody> I am trying to create a report (table) that will look at the...

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