columnb

  1. I

    How to ad the text in column B to column A

    I have last name in column A and first name in columnB. I need it to combine together in columnA ColumnA. ColumnB Steve. Smith Will look like Steve, Smith In columnA I need to do it using a vba loop
  2. I

    getting rid of multiple entries of the same name but adding a value together

    in columnA I have a name and in columnB I have a value there would be multiple entries for the same name but different values in columnB i need to get rid of the duplicate entry but the values in columnB to be added together thinkng im gonna need to run a loop in vba
  3. T

    Excel formula question

    Hi, My first post in this forum. Any help is appreciated. Thanks. What I'm to achieve in ColumnB based on ColumnA: For each ID in ColumnA, create 3 IDs with letters A, R, S appended to the ID. ColumnA ColumnB <colgroup><col><col></colgroup><tbody> ABI117 ABI117A ABI125 ABI117R...
  4. D

    VBA code to have min of 7 characters in column B and also check if column C has a value?

    Hi, Please can someone help me? I have this code and it works fine if I just want it to look at column B to see if it has a minimum of 7 characters anything less except 0 and it calls for a macro called ColumnB. 'Update Only if Column 'B' is 7 or more characters.'Try and add Column C into the...
  5. A

    More of a formula question

    I have column A, where row 1 starts with 1 and each subsequent row adds 1. For example: Column A 1 2 3 4 5 ... 100 In column B, row 1 starts with 3. Row 100 ends with 1. I need a formula that will fill in column B with the appropriate value. Here's how it should look: ColumnA ColumnB 0 3.00...

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