george

Hi all, I have a list in excel that looks similar to this: <tbody> ROBBY 18205 19206 GEORGE 16573 ANDERSON 23456 26752 47658 </tbody> I am trying to get the list so that it looks as follows: <tbody> ROBBY ROBBY ROBBY GEORGE GEORGE ANDERSON ANDERSON ANDERSON...

I would like to have names listed in sheet1 in column A, beginning at A3 and ending on A30. So if there is a name in A3 ( George) and (Sam) in A4, (John) in A5 and so on, I would like it to change the sheet names from Sheet2 to George, sheet3 to Sam, sheet4 to John, etc Is this possible?

Dear All, I have the following names in a row like below <tbody> #FFFFFF[/URL] "]Sam #FFFFFF[/URL] "]John #FFFFFF[/URL] "]Jack #FFFFFF[/URL] "]George Paul #FFFFFF[/URL] "]Mathew Joy </tbody> and I have a table on another sheet where I have the following data, <!-- Please do not...

I have two columns of data A and B. In column A i have duplicate values and in B 2 type of names (david and george). I would like to count the sum of umique values in colum A for David and then for George. This is what i have so far. =sum(1/(countif(a2:a200,a2:a200) This one sums the unique...

Need to calculate number of boxes. Need to add "TM" in another row and highlight in yellow and another blank row. Total the qty. 5 In Big Box 3 or 4 in Medium Box 1 or 2 in small box TM names vary from 1 to 15 Here is the example Any formula to do this <tbody> TM Address City State Zip...

Hi, i have the following: <tbody> Name Pass Rate Previous Score Accumulative Points Accumulative minus Reduction Result Value John 100.00% #DIV/0! 89 89 PASSED 89 Luke 0.00% 0 0 0 FAILED 44 George 100.00% 0 82 82 PASSED 82 Tim 100.00% 0 95 95 PASSED 95 Luke 0.00% 44 0 0 FAILED 63...

Want to pull a list of names that are unique from A:B and have it appear in F:G as seen below. <tbody> A B C D E F G 1 First Name Last Name Role Start Up ---------- Unique Unique 2 George Aquino Invested Initech George Aquino 3 George Aquino Invested Acme Corporation Alban Dushku 4...

Is it possible to derive a countifs using two criteria with different array range - one horizontal and one vertical. Please see example below <tbody> a b c d e f g h i j 1 Name John George Alex Allicia 2 s1 1 1 0 0 3 s2 0 0 0 0 4 s3 1 0 1 0 5 s4 0 0 0 1 6...

I am trying to stop the non completed rows from filling the response "outstanding" in the empty rows below =IF(F55="","Outstanding ",IFS(F55=D55,"Paid",F55<d55,"under paid",f55="">D55,"Credit")) If I replace the word outstanding with just "", then it doesn't put anything in the empty rows...

Hi everyone I have a list of scores for students along with year group they are studying in. <tbody> Name Points Year John 100 7 Paul 252 8 George 800 8 Ringo 53 7 </tbody> I would like to create a leader board for the Top 10 in each year group based on these scores. Year 7 <tbody>...

I am looking for a macro to copy rows from a spreadsheet and create separate worksheets based on data in Column O keeping the original spreadsheet intact. Data in Column O isn't sorted and changes almost daily so I can't hard code anything. Ex. <tbody> 1 A B H I N 0 2 Defect # Severity...

Hello there! A couple of months not touching Excel seem to have dried my brain out and I'm out of ideas. I have this type of schedule table for around 60 ppl that extends throughout the year. <tbody> 01/01/18 02/01/18 03/01/18 04/01/18 John A B OFF OFF Paul A1 B1 A B George B A OFF...