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

Some videos you may like

This Week's Hot Topics