adams

  1. G

    copy/paster to another worksheet

    I am trying to find a code that will copy and paste cells to another worksheet based on other cells value. The cells with value 1_1, 1_2. 1_3, 1_4, 1_5, 1_6, 1_7 1_8, 1_9, 1_9, 1_10, 1_11. 1_12 are the values in column f. These rows would be copy/pasted to another worksheet. Any help...
  2. G

    Add number to cell based on another cell's value

    I am trying to find a way to insert a number in Column B (Person_ID) based on Cell Column G that is Blank. Then repeat the number in Column B until reach the next blank cell in Column G. Add 1 to number and repeat, thus giving each soldier an ID number. This would Loop to the end of worksheet...
  3. S

    VLOOKUP with multiple data sets/outputs

    Good morning. I don't even really know if VLOOKUP is the formula I need but here's what I'm trying to do. On sheet 1 I have a list of names in column A. In columns B through T I have a list of training courses. Something like this: <tbody> Course 1 Course 2 Course...
  4. X

    Help in removing duplicate strings in cell without macros/VBA

    I have a number of cells and I am looking to remove the duplicate strings (2 characters or more) in them. Is this possible with an existing Excel formula(s)? It's ok if I need to use helper columns (C, D, E...) For example: A1 = Jane & Bob Smith Smith A2 = Joe Johnson Johnson A3 = Sally and...
  5. D

    Countifs/Averageifs DAX - Only one Column in Pivot

    Hi All, I'm measuring the amount of visits each employee visits one of our internal buildings. I'm attempting to do a fairly easy distinct count based on 3 criteria (date, building and staff ID). The powerpivot pivot table output shows the persons meta data (manager, org, assigned building)...
  6. J

    How to Use Conditional Formatting for Partial Text Recognition

    Hello, Have been searching and searching and can't seem to find an answer. Looking to use conditional formatting to highlight a cells that have partial duplications. Eg. Adam LL, Gatchel RI, Robinson RC Adams L, Gatchel R, Robinson R Afifi TO, Henriksen CA, Asmundson GJ, Agrawal A, Verweij KJ...
  7. B

    Background fill based on multiple text criteria

    <tbody> 2/28/18 Inv Date Due Date Inv # Amount Days Adams 2/21/18 3/23/18 5040188 9389.52 7 Adams 2/15/18 3/17/18 5040138 2220.98 13 Adams 2/15/18 3/17/18 5040139 1505.72 13 Bixly 2/26/18 3/28/18 5040223 1166.00 2 Bixly 2/26/18 3/28/18 5040221 1166.00 2 Cash 2/26/18 3/28/18 5040222...
  8. M

    Consolidating text onto one row based on a given year

    I have 3 columns of data - around 50 rows. Col A is a date (Promotion year) Col B is last name Col C is rank (this is the same for all) Data example 2017 bloggs manager 2017 smith manager 2016 adams manager 2015 bloggs manager 2014 smith manager 2014 adams manager etc Can a formula...

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