descriptor

  1. S

    Move dataset to new column when descriptor appears

    Hi, I'm trying to move a dataset into a new set of columns every time a descriptor appears. More specifically, if you look at linked images, I would like to move the corresponding dataset to new columns every time the word "particle" appears. Linked image #1 ...
  2. H

    Edit output from a measuring machine

    Hi! I have data that is output from a measuring machine. The machine outputs numerical data with a one letter descriptor of direction into each cell. For example in row one I have 0.1 H, 0.2 B, 0.1 I, 0.4 F All of the results are positive numbers with a descriptor. The descriptor tells me...
  3. M

    Merging Duplicates

    I have a roster of people with names in column B and number data about them in columns H, I, J, K. Column A has a descriptor about the person. Everyone has the descriptor of "NO" in column A when they are added to the roster. If they are added again, they are given the descriptor in column A...
  4. D

    Converting data in a report into data that be loaded into a database table

    Hi, First off, I love this board! Very helpful. I have a report (excel format) of data that has the amounts for each date in a separate column: Descriptor Descriptor Jan-18 Feb-18 Mar-18 and so forth
  5. J

    Reorganize Existing Datum With Text Formula

    I have been given many existing data coded as follows "EXMPL1A 05/25/2018 2,150.00 D" (without quote marks) each datum is this format: a descriptor, space, date in mm/dd/yyyy, space, Amount numeric with 2 places to the right of the decimal, space, alpha-character. I need to convert the example...

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