anderson

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 have a list of names layed out like below. I need a formula please to randomise them so no name is next to each other in the list. Thanks. <colgroup><col></colgroup><tbody> Louis Pearce Louis Pearce Louis Pearce Louis Pearce Anthony Ray Clive Kelly Clive Kelly Clive Kelly...

<tbody> A B A Anderson Alex Anderson B Smith Brandon Smith </tbody> - I pasted my list of names in sheet 1. - I need to FiIND A1 (entire workbook) and replace all instances with B1. - then same thing for A2 to B2 and so on so forth. Thanks in advance

Hi all. Thanks in advance for any help. I need to sum information in a new table based on the values in TWO columns in another table that may have duplicates of those two columns. Looking at the tables below, I need a formula in the “Paid to Date” column in Table 2 that will give me the totals...

Good morning. I don't even really know if VLOOKUP is the formula I need but here's what I'm trying to do. On sheet 1 I have a list of names in column A. In columns B through T I have a list of training courses. Something like this: <tbody> Course 1 Course 2 Course...

I tried to attach the spreadsheet it won't let me. I already have formulas to extract the time. The imported data is A-F. I need column L to show the difference in times. Then in column M I want to get that difference in 6 minute increments or 1/10 of an hour. So I can compare and make sure it...

Hi Folks, We have a new admin system. When the data was migrated to our new system the accounts that were held in joint names names came across with commas after each person's name. Where an account was previously held in joint names but now is an account held by a sole individual there is a...

<tbody> A B C D E 1 1 2 3 2 Anderson 1074 1261 1329 3 Camp 1118 1313 1384 4 Gregg 1079 1268 1336 </tbody> Question: If user enters the number "1" in a cell and enters "Anderson" in another cell, I want to return 1074 based on the above chart, but if user enters...

I’m hoping there is a way to make my process of emailing staff much easier I have a spreadsheet which calculates and then displays a list of staff who are out of date with training and the specific training required (result below). I have their email address set as hyperlinks and wondered if...