sue

Cell C1 has the name 'Bob' in it and cell D1 has the name 'Sue' in it (without quotes). The formula below is returning 'Bob combined net income (before retirement)' just as it should and if C1 is blank, it is returning 'Name & Spouse/Partner combined net income (before retirement)'. This is...

Hello all I hope you can help on this please In column "F" I have various territory codes In column "E" starting from row 13 I have user names What I need is IF CELL IN COLUMN "F" = "OFF" THEN ENTER IN THAT CELL THE VALUE FROM "E" (Same Row) if not leave the values in this cell Example would...

Hello, I will do my best to explain what I am looking to do. 1) Column A has a person's name 2) The top columns have all 50 states 3) The states that the people have licenses in will have an "x" in them. So it would look something like this <tbody> CA AZ FL OR NV Betty Sue X X X...

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

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

Hey all, I know it is possible to use index and aggregate to extract data row by row. But I would like to have all the data in 1 row. but got stuck there, Perhaps transpose? <!--StartFragment--> <colgroup><col width="87" span="2" style="width:65pt"> </colgroup><tbody> Sales Rep Product...

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

I have a referral spreadsheet. In this spreadsheet I track our sources of leads. One type of source I track is very specific to peoples names, so we can thank that person. Anyway, I want to see the top five people in that column. For example. column A tim john jerry sally sue tim sue tim john...

You probably read this title and thought "=sumif, dummy". However this dummy can't seem to get it to work nicely in this case. Would love some assistance. To the issue: First off, I know I could do this via VBA, but I would love to be able to accomplish it with simple formulas if possible. I...

Hi, I have three long columns of data that look like this: A B C Sam Tim 24 Tim Lee Sue 36 Ann Sue Lee 48 my goal is to match columns B and C with column A. Is there a macro I can use to match them up side-by-side and make them look like this? A B...

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