steel

  1. K

    Need to Combine Rows

    In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B)...
  2. B

    PDF to excel conversion issue

    I am converting a pdf to excel and encountering an issue where the conversion inserts carriage returns into a new cell below its dot entry. Is there a way of getting the data from the carriage return back into its correct cell entry in the row above. The conversion is on the left and what i am...
  3. A

    Copy one cell. Tp a cell; that has a sentence

    Hey Guys. This is what I have. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 316px"><col width="180"><col width="625"></colgroup><tbody> A B C </tbody> <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  4. E

    iferror Index Match - Error

    =IFERROR(INDEX($A$2:$A$60,MATCH(D$1,$A$1,0),MATCH(D$2,$B2:$B60,0)),"Try Again!") The idea is that if I choose a different cell in 'C' it will give the response from 'B'. However it only functions for the first option chosen in the matrix B1,C1. Everything else produces an error <tbody> Part...
  5. bencar

    Explain Why this Pivot Table is Layed Out this Way

    Hi guys, Trying to figure out why this pivot table is layed out the way it is. Here are my 4 questions. Below that is the exercise and its info. 1. Why is 'design' in the column area? 2. Why are 'amusement park' and 'roller coaster' in the row area? 3. Why is 'type' in the filter section? 4...
  6. L

    Getting input from one textbox and displaying output in second textbox after some calculations.

    <tbody> MATERIAL TEMPERATURE ALLOWABLE STEEL 300 423 STEEL 350 427 STEEL 400 428 STEEL 450 425 STEEL 500 419 STEEL 550 410 STEEL 600 401 </tbody> Hi all, I have a table like this where I store my values. Also I have two textboxes inside a user form. One is for inputting the...

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