adams

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

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

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

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

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

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

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

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