bob

Hello, I have Customers list that start in cell B4 that looks like this: Bob John Andy Robert And I have a Products list that start in cell D3 and looks like this: Sony PS XBOX My want to create a forumlas (i gess an array formulas) that create this table: Product | Customer Sony PS...

I am looking for a possible solution to this madness. <tbody> Column A Column B Column C Column D Name Store Visit Store # Date Bob 126 7/12/2018 Jennifer 126 7/12/2018 Chris 126 7/12/2018 Bob 126 7/12/2018 Bob 113 7/12/2018 Susan 156 7/13/2018 Gregory 156 7/13/2018...

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

Hi, I have a report that is run from another system, and unfortunately there is no way of altering the format of how it outputs the data. An example of what I get is: Anne 9:00 10:36 a 11:49 13:34 c 14:35 15:10 a 17:00 bob 7:20 7:45 a 8:00 8:45 9:00 c 10:00 11:00 a 13:00 carly...

<tbody> AUS BOB BOB DREW HOU DREW BOB BOB DFW DREW NANCY DREW CRP BOB NANCY NANCY NAS NANCY DREW DREW </tbody> Hoping someone can help with this. I have a spreadsheet like this I need t be ale to pull the list of data in column A based on a give name...

<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've seen formulas that can extract unique values from a row or column, like {=IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"")} but I can't make this work for a range of cells, like this: <tbody> A B C D E F G H I J K L M N 1 Bob Alice David 2 Mark Alice...

Guys I am working on a spreadsheet and need to buils a search page. I have 5 tabs where the columns are <tbody> First Name Surname Age URN length of service Bob Smith 33 qz445566779 3 years julie Paige 27 fd4775h33 2 years Bob Smith 34 ttt6767655 6 years </tbody> The sheets are...

Hi I wonder if you can help me I have a spread sheet of training for my staff <tbody> Student Course one Date started no. attempts mark acheived date completed Course 2 <tbody> Date started no. attempts mark acheived date completed </tbody> <tbody> Course three Date started...

Hey Guys n Girls I am trying to automate a data spreadsheet with the above functions. What I have is spreadsheet to record Higher Duties and Column A is Payroll Number Column B is the staff name via a drop down box and Column C is their current pay increment so I have started on a formula...

Hi, unsure how to do this from a Txt file In the following format Name,Country Jim Jones,Australia Bob Frank,UK Want it to load into my sheet "Users" and overwrite current contents. Any help appreciated

Hello, I am trying to create an excel table that can filter a column based on what is in each cell (using autofilter for now). I was wondering if there is a way to have multiple values in a single cell within that column? Example: <tbody> Name Flavor (filter) Bob Cherry, Chocolate...

<tbody> Name job Date Bob Worker May 12 Bob Firemen May 13 </tbody> The above data is from a LINKED response form. Is it possible to have row 1 deleted due to row 2 having the same name?

Hi guys, I am fairly new to excel so I don't know very much. I have done A LOT of googling and trying to figure things out - and so far I have succeeded pretty well. However, there are 2 things that I can't seem to find the answer to (and honestly I have a difficult time understanding some...

Hi, I have an very large excel sheet, changes regularly with new info, what I need to do is copy part of this into a blank S/Sheet but I do need multiple entries depending on a criteria In Column A I have a name EG Bob In Column B a number value EG 3 What I want to do is copy the data in...

Hi all I currently have some code that copies and pastes rows, a variable number of times dependant on data in Supervisor Name field, to a new sheet. What I am looking for is a way of adding a cell prior to the pasted data, populated with 'Call 1, Call 2 etc. which references the number of...

Hi every one, I need something that is quite complex and so I'm trying to explain it the best I can, apologies for any ambiguity. So, I'm setting up a tracker for the work done on clients by employees and similarly the work that the employees have done, I need to be able to see both at a...

Hello guys, Can anyone think of a way to add a value to every Nth cell that has a repeating value? Example: <tbody></tbody> <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> Bob Bob Bob Bob Bob Bob Bob Bob...

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 a list of classes, teachers, and periods. I need to sum the periods for each teacher when their name is typed in. The problem is that the data is not arranged in a 3x2 grid. eg Math 8 3 Joe Math 9 4 Joe Math 10 5 Sam Eng8 4 Lucy Eng 9...