tim

Hi, I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have their street address, city, state, and zip in concatenated in on line based on their ID. For...

Hello All In sheet 1 I have the following <tbody> HELPER 2 FIRST NAME HELPER 1 LAST NAME LAST, FIRST 1 BILLY 6 SMITH SMITH, BILLY 8 ZEE 7 WORD WORD, TONY 7 WILL 2 HAYES HAYES, WILL 3 PAUL 3 MORRIS MORRIS, PAUL 6 TAMMY 7 WORD WORD, ZEE 5 TIM 4 PARKER PARKER, TIM 2 JACK 5 PRICE...

Hi, Hope that someone can help me if this is possible to do in a formula. Sorry that I can't post screenshot of table because I couldn't get the add-in to work. :sad: Name Run Out Tim 6 1 John 5 3 Len 6 3 John 3 4 Len 4 2 Tim 2 3 How i would like to...

<tbody> A B C D E F G H I Result 1 Matt Tim Joyce x x x x x x Dup 2 Kyle Joyce Tim x x x x x x Unique 3 Joyce Matt Tim x x x x x x Dup </tbody> Hello, I have 9 columns A:I, and have around 2 rows 1 - 21. In each of these cells there I a name...

Hello, I have a column of names on sheet1 Names Tim Hanson Bob Jones-Kelty Hank Edward Williams On sheet2 I have two columns First Name and Last Name in columns A & B First Name Last Name Tim Hanson Bob Jones-Kelty Betty Anderson Hank...

In cell B1:B10 I have a value of 100, in cells A1:A10 I have values of 95-104. I need a formula that increases values in B2:B10 by 0.1 until they are equal the cells in A1:A10. Thanks Tim.

I have the following data, but much longer. What I want to do is take the average of the total summed hours. I have categories with sub categories with sub categories below that. In the pivot example below when I select average it averages by person. What I want is the average by the total...

EDIT: How do I attach an example workbook?? Hi, I have recently posted on a different Excel forum with no luck relating to my current issue. The workbook in question is a tracker of mixed-martial arts fights. The issue relates to tracking the current and past champions. I am trying to fill...

Hi, unsure how to do this, as theres is sometimes gaps in column A <tbody> ID Name Helper Column 001 John =B2 002 "this should output "John" 003 "this should output "John" blank 004 Tim "this should output "Tim" 005 "this should output "Tim" 006 "this should output "Tim"...

Hey all, I know it is possible to use index and aggregate to extract data row by row. But I would like to have all the data in 1 row. but got stuck there, Perhaps transpose? <!--StartFragment--> <colgroup><col width="87" span="2" style="width:65pt"> </colgroup><tbody> Sales Rep Product...

I am attempting to have several users input onto different sheets. What I would like to create a sheet that has a running list that will update as inputs are put in? This is not actually done in microsoft Excel. It is being done in Google sheets. Example Sheet 1 Sheet 2 Sheet 3...

Say Bob Smith earned 13 raffle tickets Tim Harding earned 30, etc etc. Is there a formula that you can input that will create 13 versions of Bob Smiths name and 30 of Tim Hardings?

I have The following in a table in Cell A1:B6 I have the Car (Audi BMW) listed in cell C1 and D1. And need to obtain all the names under each car. eg tom and tim would be under BMW. Need this in a VBA code please <tbody> NAme Car phil Audi andy Audi jack Audi tom BMW tim BMW </tbody>

Dear mrexcel community, My questions is; <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Item 1 10 20 40 10 Item 2 20 20 30 10 </tbody> Suppose there is a dropdown menu for item 1 and 2. When...

Hi, I have three long columns of data that look like this: A B C Sam Tim 24 Tim Lee Sue 36 Ann Sue Lee 48 my goal is to match columns B and C with column A. Is there a macro I can use to match them up side-by-side and make them look like this? A B...

<tbody> A B C D E F 1 HA Test 1 HA Test 2 HA Test 3 Criteria 2 Jim 10/09/17 (C) 10/09/17 (A) 10/09/17 (C) HA Test 1 3 Jane 10/09/17 (A) 10/09/17 (C) 10/09/17 (A) 10/09/17 (A) 4 Roger 10/09/17 (A) 10/09/17 (C) 10/09/17 (C) 5 Tim 10/09/17 (A) 10/09/17 (A) 10/09/17 (C) </tbody>...

<tbody> A B C D E F 1 HA Test 1 HA Test 2 HA Test 3 Criteria 2 Jim 10/09/17 (C) 10/09/17 (A) 10/09/17 (C) HA Test 1 3 Jane 10/09/17 (A) 10/09/17 (C) 10/09/17 (A) 10/09/17 (A) 4 Roger 10/09/17 (A) 10/09/17 (C) 10/09/17 (C) 5 Tim 10/09/17 (A) 10/09/17 (A) 10/09/17 (C) </tbody>...

Good Afternoon All, I generally have been able to learn a lot from this forum and get all my questions answered just from reading other threads. However I am stuck and wanted to see if the community can help me out! Here's a quick and dirty example of my worksheet: Columns A - E contains...