alan

Hi Guys, bit a headscratcher, I have a roster that im trying to calculate. The roster has several employees, each with there own colour and how many hours they have, eg, A1, A2 and A3 are Green and have 1 in each cell. So lets say Alan, who is "green" will have a total of 3. Is there a...

HI GUYS, I am trying to get the min and max date for a customer from the data below <tbody> Name item qty start date end date Alan S 3 <tbody> 01/09/2013 </tbody> 31/12/2014 Alan S 5 01/11/2015 31/12/2016 Alan S 2 <tbody> 01/01/2016 </tbody> 31/12/2017 </tbody> i want...

I have a spreadsheet that calculates handicap changes - I would like script (if possible) to do the following: The first step is that the total cell (for each row) picks up the last 3 scores if they qualify A formula will then decide if a handicap change is due. However if a handicap is...

<tbody> A B C 1 NAME SCORE WANT THIS 2 Cathy 75 Dan 3 Bert 50 Cathy 4 Cathy 75 Alan 5 Bert 50 Bert 6 Alan 50 7 Dan 100 </tbody> Hello all. I'm looking for a formula for C2 (copied down). The formula returns a unique distinct list (removes duplicates), in descending order of...

<tbody> Dear All, I have data as per below and I want to make a summary in VBA, like the table on the right side in bold, which shows by Name, by category the values sold and it should be by month, but my dates are as per below, so if i have January then it should be 31 columns. I have...

hi, i have a workbook with two sheets (sheet1 and sheet2). Sheet 1 has the First Name, Last Name and Location of each user. <tbody> First Name Last Name Location Paul Allen New York Whitney Campbell Chicago Alan Baretto Los Angeles </tbody> Sheet 2 only got First Name and Last Name...

Hi, I got this raw data that shows list of people who do delivery packages in a month <tbody> MON-1 TUES-1 WED-1 THURS-1 FRI-1 SAT-1 MON-2 TUES-2 WED-2 THURS-2 Andrew 12,00 12,00 12,00 Ashely 12,00 11,00 12,00 Alan 12,00 12,00 12,00 12,00 Billy 12,00...

Hi all, I'm looking to run a series of copy pasting and duplicate row macro. I need to: (1) Copy paste y2:z2 to ab2:ac2 (2) Autofill ab2:ac2 to last row (data in column to the right) (3) Copy paste ac2:ae* (eg ae18) to another sheet (a2:c*) Then: (4) Copy paste y3:z3 (until last row of...

<tbody> robert alan josh sara concatenate w/header 3 4 5 robert (3) & alan (4) & sara (5) 2 8 alan (2) & josh (8) 1 6 alan (1) & sara (6) </tbody> let me see if i can explain this clearly. i am trying to come up with a formula for column E that if the cells in that row's range are...

Hello I have a table (my table will never start from A1) For ex: I have the nr 13 and column name "Sat" And I need the row header: "Alan" unfortunately I can not use : =Index(E8:E10,Match(("13",G7:F10,0)) because I get an error. <tbody> E G E F 7 Fri Sat Sun 8 Alan 20 13 4 9...