amy

I am looking for a formula which can assign a code based on predefined criteria <tbody> A B C D E 1 Strategy Name Area Calls Priority 2 S1 Amy Bakery 0 3 S2 Jane Bakery 1 4 S3 Jane Bakery 1 5 S1 Amy Bakery 0 6 S1 Peter Bakery 2 7 S3 Peter Bakery 2 8 S2 Jane Bakery 1 9...

hi guys Data as follows <tbody> a b c d e 1 john amy 2 bob bob 3 tim keith 4 amy emma 5 becky lisa 6 keith john 7 george lisa 8 dan dan 9 lisa tim 10 emma becky </tbody> What I need is a formula (preferably, I don't like macro's!) in e that...

Hi There, I'm analyzing a large amount of time entry data (30,000+ rows). I'm trying to calculate the day a project started and ended for one person...in the example below I'm trying to solve for when the project started and ended for Amy (via a function). <tbody> Project # Name of Person...

Hi guys, I'm a vba newbie and im currently having some issues writing out some vba code for this situation. So I have a 1) Base worksheet which contains: My base data: Column B: different names of people column A, C-J: other information which i pick and choose in the code below to copy and...

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

I have a list consisting of names in column A. I would like to type the name in a cell and would like to see the names that match that criteria. for example: the list has the following names: SAM JOHN THOMAS JOHN JOHN THOMAS NEIL WILSON JOHN AMY AMY JOHN AMY GARET IF I WERE TO TYPE IN THE...

I have data on sheet1 that is organized with a multiple lines for each Car. I'm trying to consolidate the data on Sheet2. I have copied and removed duplicates to sheet2, and i'm wondering if there is an easy way to achieve the bottom chart. Basically, I'd like to insert a new column to B and...

I am trying to look at a user log data set and assign a team based on the user name and the date. I have a seperate table with user names and the dates they were on the different teams. VLOOKUP will find the first entry for the user but I can't figure out how to have it also look at the date...

In A1 i have: =INDEX(D2:D6,MATCH(LARGE(E2:E6,C2,E2:E6,FALSE)) This formula returns the top most valuable customer (dog). But there is a tie for second place (cat and amy) but it returns Amy Twice. How do i fix this? Ty <tbody> A B C D E Waffle 90 1 Dog 30 Amy 50 2 Cat 50 Amy 50 3 Amy 50...

Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is a simple, example of the data I have: <tbody> Name Product John Brand A Mark Brand B John Brand C Amy Brand A Amy Brand D Amy Brand C </tbody> And then this is my desired output...

Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is simple, example of the Pivot Table I have put together so far: <tbody> Brand A Brand B Brand C Brand D John 1 2 Mark 1 Amy 1 1 </tbody> Essentially I am trying to put together a...