tim

  1. L

    Power Query to Concatenate Rows Based on Condition

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

    Automatically Alphabetize Names

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

    Summary of name and cocatenate data

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

    Check for Duplicate Rows in Mulitple Column

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

    split cells in a column by a sub-string and place the sub-string and its compliment in to adjacent cells on same row

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

    0.1 increments

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

    Average while removing duplicate values

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

    Separately counting occurances of consecutive values of the same name

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

    Need help with formula to fill entries until different value

    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"...
  10. A

    Formula Help. (One condition transfer all)

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

    creating list with input from several sheets

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

    A formula to create the # of names you need for a "drawing"

    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?
  13. R

    VBA - List from Table (simple-

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

    sum values selected variance in the list

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

    Match two columns with one column

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

    Index & Match (list more than one match)

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

    Index & Match (list more than one match)

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

    Assistance Needed With Determining Which Functions To Use!

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

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