joe

Hello all, I have shared two tables below, first one is a DATA SOURCE and second one is the DESIRED RESULT. I want the DESIRED RESULT in yellow highlighted columns in the 2nd table. I am looking for a particular formula which can read and match the product ID from DATA SOURCE and distribute...

Hi All, Wondering if someone could point me in the right direction and help please - I have a workbook that I generate other workbooks from, so from the dataset in the main tab a macro sorts the data and then for each name, generates another tab with all the respective data on. For example...

Hello, I am having issues figuring out how to essentially do a VLOOKUP searching for CONCATENATED or AMENDED information Explanation: On one sheet, I have names with unique values that I could use for a vlookup for agents that go to different trainings: Smith, Joe could have the following...

Hi MrExcel World, I am trying to concatenate 2 cells, which is easy enough. The problem I am having is that one if one of the cells is blank I don't want to return anything. Example below; Concatenate----------------------First Name----Last Name John...

If I want to add/insert the name Mary (after each Larry) to the Excel column below, without typing in Mary about 10 or more times, what menu would I use? <tbody> Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris...

Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...

Hello all, I am hoping someone can help me. There is a report that shows user files being backed upsuccessfully or not. In column D is the success status. If a backup fails it tries again up to 3 timesthat same day for each user. The data issorted by username and in date order. My example...

I have a large database for a Genealogy Project. User will choose a family. From my Database each family has a unique number. Based on The family chosen. I have created a range of all the names in the family using the inique family number, to update a death. Because that person may have been...

Hi, When you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name? Tom 0.5% Joe 0.25% Brad 0.25% Bill 0.35% Charlie 0.26% Tom 0.6% Joe 0.30% Many thanks

Hi. I have a table containing staff member names (column A), team they belong to, which is numbered between 1 to 30 (column B) and contact info / location info in columns C and D. The whole range is A4:D434. What I'd (ideally) like to do is have a Userform pop up and show all of the staff...

I am attempting to count the unique values in one column where a criteria is met in another column. (Assume the following data starts in cell A1.) I want to count the number of different Names in Office 1. (The answer is 3: Joe, Lisa and Betty.) I don't think the COUNTIFS function will work...

I have been given a list like so; stan smith joe wilson ken hanson mike jablonski I would to have the list look like so: stan smith | joe wilson | ken hanson | mike jablonski the substitute value only works with a specific set value. so it would set the first delimited between smith and joe...

Hi I have a spreadsheet im trying to complete which if done manually will take forever but i cant work out how to automate. In one sheet i have information as per the below Date Employee Name Holiday taken 02/06/2018 Joe bloggs 03/06/2018 Joe bloggs 06/06/2018...

Hi All I've been trying to rack my brain for ages just cant work out how to use a formula to force user to end entry with 7 numbers. (Case of the letters is not important) For example these should be ok: Hill J 1234567 Joe R 1345647 Smith 9864567 These should fail: Hill J Smith Joe R 123...

Hello Excelgurus, I've incorporated a bunch of checkboxes in my workbook. The captions of those checkboxes are the first names of staff members. I've added those checkboxes manually and I also manually changed the caption to that particular person's first name. I was wondering if it's possible...

Hello, I got two set of data that needs to be align by id. I need a formula/vba to go down two sets of number and insert a blank line if there's no match and go on to the next number. One set of data is a-d and the other is f-i. I was only able to find something that only insert blanks into 1...

Hi All I have a huge data file (1000000 rows) that shows amongst other things: Customer Number, Name, Item and Value. Im wanting to reduce the data set by combining multiple rows that are for the same person and the same item. For example in the table below I would like to combine Joe Bloggs...

With help I got here some time ago, I was able to build a table that shows how often a string from a master list occurs in a reference list. <tbody> R/C C D E F G H 4 Master Tally Reference # Errors Type Formula in D 5 jane 2 jane sally polly 0 D5: =COUNTIF($E:$E,"*" & C5 & "*") 6 Joe 3...

Want formula to sum the same cell across multiple unknown number of sheets where the last 5 digits of the sheet names match the last 5 of the active sheet Tab names= Jane 16-17 Fred 17-18 Joe 17-18...

Hello, I have data set example as follows: I want to call out the duplicate names so if A! and B1 match AND B1 and B2 match then place an X in C1 and C2. Is this possible with a formula (not VBA) or other option? Thanks in advance! A1 Bob B1 Jensen A2 Bob B2 Jensen A3 Tom B3 Allann A4 Bill...