bob

Hey - I'm not sure how to accurately describe this question in the title, but here it goes. I have two columns with data, and one review column. I am looking for help creating a worksheet formula which will count how many unique values in column 2 are associated with the value in column 1...

I have a set of data with Departments, Names, Dates of Expense, and Expense Amount. Currently the data is set with the Department and Name in Columns A and B // Jan - Dec as the heading // Expense Amounts in each cross section: Department // Name // Jan // Feb // Mar Accounting // Bob // 5...

Hi all, I need help with a formula, and I'd be super happy if somebody could help me. I have explained the issue in the table below. Maybe it's possible to have a macro or similar that can "go through" the file and automatically correct the dates? What's the best solution you think? The output...

Hi, I need to find a COUNTIF (or something similar) formula. Right now I do this by hand and it takes absolutely forever. Please see below. Is there any way to achieve this with a formula? Thanks so much! I need to create a COUNTIF function that does the following (in sheet 1 column 2): 1...

Hi, I have a table like below. I have a formula in another sheet that lets me know how many apples Bob bought on day 1 - it works great: =SUMIFS(Sheet2!C:C,Sheet2!A:A,"Bob",Sheet2!B:B,"Apples") BUT I need excel to sum the "month to date" as well to see how many apples Bob has bought so far...

Hi Everyone, I'm try to make a list based on a name selected I'm getting stuck so please help if you can Column A has names in it Repeated lots of time with column be having interests, <tbody> A B C D E F G H I 1 nAME Interests Sub Chosen Name Unique List G is what i'm...

Hello, I have the following formula: =SUMIFS('Splits-YTD'!D8:D1050,'Splits-YTD'!F8:F1050,A8) the name under A12 is as follows Bob Smith. Under the tab Splits-YTD the name can show up in column F as follows: Bob SMITH or BOB SMITH or Bob Smith. My current formula doesn't seem to be catching...

Hey guys I am trying to find the subtotal of numbers in a column, However whenever the number is greater than 9 I would like it to calculate X1.5 How would I go about getting that? Name Total Hours Bob 9 Bob 7 Bob 9 Bob...

I have 2 worksheets I need to combine - I need the data from the 2nd sheet that matches the first sheet to be put in the Post-test Q1, etc. So Sam from the second sheet would be ignored, Bob's data from 2nd sheet would be put into 1st sheet in appropriate place. Trying to match pre and post test...

I have a macro that creates a copy of 11 sheets within a workbook and creates a new workbook for each of the 11 sheets. The macro then saves each workbook with a specific name e.g. Bob, John etc etc. What i'd like is at the start for a text box to come up so that the user can define the first...

Hello! There are two input tables. Input 1 is a schema (e.g. what can be bought) which is followed by entry table in input 2 (e.g. what was bought). How to read If key is Bob, then there are 3 variables named apple, pear and orange. Now using the schema Bob, we placed an order for 20...

Can't understand where this formula is going wrong. =SUM(SUMIFS(A:A,B:B,{"bob","tim"},C:C,{"North","West"})) If I amend all entries in col C to west it returns for tim and if I amend all to North it returns for bob. I need it to return for both bob and tim irrespective if north or west.

hi experts! I have two tables in two separate sheets. I need to Match and lookup outcome from Sheet 1 to Sheet 2. <tbody> Date Name1 Name2 Outcome Outcome 21/09/17 Adam Maria W L 20/09/17 Donald Michelle L W 19/09/17 Kate Bob N/A N/A </tbody> In different sheet I have...

Hello, I have a data set from A1:H2 and seeking solution in I1 and I2 from Reference list in A7:B15. For Bob, I need to lookup the values in A1:G1 against the reference list and return the value corresponding to the last nonblank instance. Thanks in advance! <tbody> <colgroup><col...

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

Hi, I want to do a vlookup with 2 different criterias. I am able to achieve the result by either using a helper column or by using array formulae. Is there any way, this can be done without either of the two (without additional column or array formulae) E.g. Here is my data set: A 1 Ash B...

<tbody> A1 Bob(B1) Mary (B2) Nina NINA (A4) </tbody> I'm wondering if there is a formula that is available that will search B1:B3 and if it matches A4 (NINA) it will then anything in Column B that matches to uppercase or to mirror A4. So I'd want it to then change it to look...

So here is what I am trying to achieve <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Person Case# Joe 17 Y Bob 17 Bob 18 Y Doug 17 Doug 18 Doug 19 Y </tbody> I want the third col to "trigger"...

Hello everyone, I have something I want to do, but I have no idea where to start, so here is the problem : I have many excel files : On the file a.xls I have this <tbody> Igor 10 20 10 Patrick 30 30 10 Bob 20 20 20 </tbody> On the file b.xls I have this : <tbody> Igor 20 30 40 Bob...

I'm trying to use an INDEX search instead of a VLOOKUP because I want to display all associated cells with one String in a cell. For example, if my String is "Bob", I want to be able to search Column B for all instances of "Bob", and then produce all associated values from Column C. This...