mary

Hello All- I have a dataset that I need to utilize the transpose function. Dataset I currently have: Mary Smith Region 1 Dr. A Mary Smith Region 1 Dr. B Mary Smith Region 1 Dr. C Mary Smith Region 2 Dr. E Below is what I need the data to be: Mary Smith Region 1 Dr. A Dr. B Dr. C...

<colgroup><col><col></colgroup><tbody> Name Item John apples Mary oranges Bob grapes Sue oranges John oranges John lemon John celery Mary grapes Bob oranges Sue celery John apples,oranges,lemon,celery Mary oranges,grapes Bob grapes,oranges, Sue...

I am trying to combine data for users who have multiple rows into one single row. All other data is the same except for one column, so I want that one column to reflect all of the data in the first column for that user, separated by commas. Current Sample <tbody> Login_ID Sys1_ID Emp_No...

Hi all, I have a challenge that I cannot quite figure out... <tbody> COLA COLB COLC Ray 100,000 Mary Ray 50,000 John Sam 80,000 Sam 60,000 </tbody> I would like to have a sumproduct or sumif formula that can add up the total amount for each person. Where there are two names on a...

I have a Spreadsheet which I have linked to other sheets effectively, (thanks to this board). I now want to go one step further and be able to write in a name in a column and within the same column, return a number (in this case a duty no.) I have tried Vlookup, if and match and so far, I have...

Thank you in advance. I have a spreadsheet with participants winning multiple awards. I want the awards in separate columns tiled Awards 1 Award 2 Award 3.... I have this... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Award Jane Gold...

Hi , I'd like to know how to merge rows based off unique id values. Lets say I have: <tbody> ID Name @345 Jack @532 Mary </tbody> and another sheet with <tbody> ID Age @345 32 @532 38 </tbody> ... I'd like to be able to combine sheets based off id to append data <tbody> ID Name Age...

Hello forum! I have a question for you knowlegeable people; how can I change what's in a pivot's values without actually going to the PivotTable Fields area. Ideally, I'll be using a slicer. This is the raw data: <colgroup><col><col><col></colgroup><tbody> Name Document No. Values John...

I'm trying to figure out a way for a User to select the names of workers that are in the office, then have VBA place those names in cells based on the value of another cell. I would like for the User to click a button on a form, that launches another form (let's call it...

I have a large amount of unique values that are categorized under 3 names in one sheet. In separate sheets I want to be able to pull out the values by each name without skipping a row. See below. In the example below is what I have in Sheet 1 on the left - all unique values under 3 names. In...

How do I design a pivot table that will allow me to add additional data past the last pivot table fields? In the example below would set up pivot table in rows for Name, Address, City, State, Site ID. But would like to have he additional data to also be added... DataX, DataY, DataZ. Thank you...

Hi I have 2 tables. I want to create a pivot table from it. I tried ALT+D+P but did not work. I watched a video and they said both tables have to have same # of columns!! but that is not the case with my me. What should I do? Thanks you <tbody> name hired date mary john </tbody>...

Please can you help with this problem - See table below: I would like to put a formula in Colum C that adds up the total per person. So it needs to: a) find everyone with the same name in Column A (e.g. everyone called John) b) look in the corresponding row in Column B and add up all of those...

Hello! I'm trying to bend Excel to my will but it refuses. Here's an example of my data set: <tbody> Date Name 1/4/18 Mary 1/4/18 Mary 1/4/18 Mary 1/5/18 Fred 1/6/18 Mary 1/6/18 Mary 1/7/18 Fred </tbody> Each date is a day someone worked. Each name is the name of the person...

Hello, I am trying to find a way to count unique values across multiple columns, but not a combination of values across both columns, but rather unique values *across* both rows. For example: Column A Column B Mark Mary Mark Steve Mary Linda Mary...

I am looking for a way to transfer data between two different sheets. All are ActiveX controls. On Sheet1 there is a textbox and a button. On Sheet2 there is another textbox. When the button is pushed on Sheet1, it should take the string in textbox1 and copy it to the text box on Sheet2...

Hi All, I am trying to create a Best Performer Cell which would show the name of the best shop performer. Mary, Sean and Leane all have 100% insurance but Mary only did 1 sale where as sean and leane did 10. but mary is listed as the best performer as her name is higher up the list. to give...

I have a rather large dataset (sheet1) that contains names, year and grade Example key dataset fields Name Year Grade Fred bloggs 2000 A1 Mary Smith 2016 A2 john Jones 2017 A1 John Bloggs 2016 A3 Ros bloggs 2000 A3 I can filter / copy the data onto sheet 2 on any of the criteria But I would...

Hello, I need a formula that will: Refer to a specific cell E1, check if E1 has any value at B column in table "Table1" (A1:B8). In table "Table1", at B column, there are different values (including duplicated values) corresponding to cell E1. If a specific text "Mary" is available, then...

Hi, I've been trying to find mutliple hits matching one criterion (column E) so as to produce the following results in column F: <colgroup><col span="5"><col></colgroup><tbody> A B C D E F TYPE NAME CRITERIA RETURN VALUE 1.0.1 JOHN 1.0 0 1.0.1 JOHN 1.0.2 MARY 1.0.2 MARY...