plate

  1. D

    Advice on keeping data current across 2 sheets

    Looking for advice and help. I have a user form that can enter, search, edit and delete information that I need to expand on. Currently all the information is stored in 1 sheet, "Data". Which is the source and copy location for a filter for the "master data" (if you will). For example, if I...
  2. B

    Lookup formula

    <tbody> job task charge codes prices N34 cable mod plate 125 cable 40 N35 cable socket mod connect 10 N38 socket connect mod plate 15 N44 cable plate socket socket 25 mod 70 </tbody> hi i new to advance formulas and i need a formula to look at the...
  3. I

    How to Separate Parts of Text from One Cell into Multiple

    Hello, I have a string of text in a cell that I need to separate into multiple cells, Text to Columns will work however I need a formula to do this as I don't want to have to break this out every time I refresh the data. I don't think LEFT, RIGHT, or MID functions will work since the number...
  4. 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...
  5. K

    Looking Up Data Based on a Future Date and Another Criteria

    Hello, Hope someone can help with this. I have a worksheet with a list of products, dates, delivery locations and amount being delivered (units). The products can be duplicated, as can the dates, but the delivery locations will be different if this is the case. <tbody> Product Date Delivery...
  6. S

    If multiple duplicate values, then return max value from third cell

    Hi, I have an excel table with 20000 lines. Here is a short sample it, with license plate number (column B) which last process phase they have gone through. There are some duplicate values in the plate numbers, which have been indicated in column C. In column D, I would like to return for each...
  7. T

    Quick Append in Power Query???

    I have a table that has the following Format <tbody> Plate Group Count Market Cost/LB Markup Markup % <= 1.5 and <= 120 319 .46 .39 .07 18% </tbody> I am trying to see if there is a simple way to convert that to <tbody> Plate Group Type Value <= 1.5 and <= 120 Count 319 <= 1.5 and <=...
  8. K

    Inserting row in one sheet inserts same row in second sheet? (primary key?)

    Hi! I have a situation where my Excel spreadsheet has become so large and unwieldy that I'd like to have some of its data in one sheet and some in a second sheet. The data can all be connected by a primary key, in this example the license plate of a car. The first sheet will list information...
  9. D

    VLOOKUP across 7 worksheets

    Hello, I've really looked online and attempted to copy/paste but I'm having difficulty with this. I am trying to develop a vehicle database for my company so that all employee cars are documented (each tab represents a specific department). That's the easy part. What I'm having issues with on...

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