bob

Hello, I have a combobox that I'd like to populate with various people's names based on if they pass certain qualifications. So for example: <tbody> Names Run Pass Catch Bob Y N N Jill N Y Y Tony Y Y Y Mary N N Y </tbody> If I would like to populate that combobox with people who can...

Hi . I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column. I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes...

Hi, to any Macro coders out there, I am trying to create a basic spreadsheet with a macro that does the following: On the first tab, there are two columns. A1 reads "Name" and B1 reads "Code". As an example, cell A2 contains "Billy Bob" and cell B2 contains the number 5236. On the second...

<tbody> A B C 1 Name Points Current Leader 2 Amy 10 Amy 3 Bob 5 Amy 4 Amy 2 Amy 5 Caleb 15 Caleb 6 Bob 10 Caleb 7 Bob 1 Bob 8 Amy 4 Bob 9 Bob 1 Bob 10 Amy 2 Amy </tbody> I'm trying to find a formula for column C, which outputs the person with the greatest accumulated score...

Hi, I am looking to do the following, but my excel-fu is weak.... I have twelve tabs, one for each month. Each Tab contains a list of people, and the data pertaining to them, like the following <tbody> Name Nuts Bolts Widgets Objects Bob 12 14 6 6 Ted 11 16 5 5 Amy 9 17 12 9 Jeff 8...

<tbody> Quarter SR Client q1 jane abc company q1 jane mcg inc q1 jane mcg inc q1 house box llc q1 bob hti q2 bob hti q2 bob apple q2 jane abc company </tbody> I have this set of data. I want to do two things: 1. calculate the number of total unique clients by Quarter and SR...

Hello, I'm trying to automate the calculation of counting the number of employees on my team if they are full time (as opposed to part time). Sometimes, I filter out some employees on my list, and that will impact what is shown on a graph. What's the correct formula do do this to account for...

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

I've written nesting if(ands) but I'm wondering if I can have an If(or do what I want it to. I'm looking to have one formula look at a set cell position A2 on sheet 1 "Bob Builder" and then compare that to sheet3 A2:A1000. If it's "Bob Builder" then return the values in sheet3 B2:B1000. But I...

Hello all, this is a little complex. I would like to produce a vlookup but the value it produces is another formula. for example, I want to vlookup (or index match) bob - i want the value to then produce the formula of "=A2&B2" in another sheet, not the value, is this possible? the formula...

Column A of sheet 1 is populated with names.....via list validation Column U of sheet 1 has a $ amount Lets say in A2, i select the name Bob Jones.....fill out some other stuff and the total cost in U2 is $400 On sheet 3, B2, I have this formula...trying to capture the total number of dollars...

I don’t know what to call this, but someone has had to have done this before. Sorry if I’m searching for the wrong words on here, but I can’t find the answer. Thanks for your help in advance. I’m getting a data dump of random contact information, most of it I can sort pretty easy except the...

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

I am not sure how to do this with a data set I have... Data: <tbody> Customer Group Week 1 Week 2 Week 3 Week 4 Bob A Yes Yes Yes Mark B Yes Yes Sue A Yes Yes Tim A Yes </tbody> List the week and each person that has a 'Yes' in that week. Would prefer to do this in a...

I have a basic Table of Projects similar to this: Project Name Month Proj01 Bob 1 Proj01 Bob 2 Proj01 Bob 3 Proj01 Jack 4 Proj01 Jack 5 I can take table out to excel and add Min & Max formula to present as: Project Name StartM...

I have a spreadsheet with 1000 rows that look like this: LNAME FNAME YEAR DONATION Adams John 1995 100 Adams John 1996 150 Smith Bob 1995 100 Smith Bob 1997 175 Smith Bob 1998 150 I want to transform the spreadsheet to this, with only one line per donor: LNAME FNAME YEAR DONATION YEAR DONATION...

Is there a formulaic way to turn a list in two columns like this: <tbody> Albert 3 Bob 2 Charles 4 </tbody> into a new list in a single column like this (where the number of times that a name appears is dynamic based on the number next to it in the original data like above): Albert...

Hi all I have a list of names in a column A and a list of categories Cols B-F Each person can be tagged to several categories with the value of either 0 1 2 3 or 4 I am after a way to create a separate summary sheet that will tell me the person’s name in one cell (which I can do with...

In my excel I have a person entered 3 or more times. Credit score example Bob Jones 760 Bob Jones 750 Bob Jones 740 I want to remove the duplicate Bob Jones's but keep ONLY the TOP entry which is 760 the Highest. I already have my sheet auto sorting so the top one will always be the HIGHEST...

I want find out if B2 in Sheet1 exists in column B or C in Sheet2. If B2 exists in either column B or C in Sheet2, I would like to display Yes or True. If B2 does not exist column B or C in Sheet2, I would like to display No or False. For example: Sheet1 <tbody> A B C (Does value exist in...