surname

Dear Experts I had to complete a huge excel cleaning job and was not provided time. Please refer to the attached input and reference output tabs. I have excel column, with names in various formats, I need to compare each cell of this with master database and if matching print the row number...

So this is the issue: If Name (column A), Surname (column B) and Mark (column C) match with list of Name (Column E); Surname (Column F) and Place (Column G), then answer is YES, otherwise NO. I tried with =IF(COUNTIFS($E$2:$E$5;A2;$F$2:$F$5;B2;$G$2:$G$4;C2);"YES";"NO"), but didnt get correct...

Hi all I know there's been multiple posts on this throughout the past but all with slightly different requirements... I have a list of c.1500 names (some with middle names, some without) and i'm trying to split them out by title, first, middle (if there is one) and surname. I've tried text to...

Hi, I currently have a ComboBox drop down on my worksheet which when i click on the drop down i see the list of customers from A-Z in the order of First name then Surname. I need the same but Surname then First name. I have copied the existing code & changed the relevant items but need some...

Hi all, I’m working on a simple sheet where I have a few columns. The important ones are: A = first name B = surname F = points On another sheet within the same workbook I am trying to get it to display any person who has 3 or more points. I want it to display first name, surname and points if...

What formula can I use to identify two consecutive consonants in the name and surname columns.eg name Ndoluvo and surname Khaye formula should identify any two consecutive consonants the name and surname starts with

Good day Please can I ask for assistance. I would like to transpose data I have client information in row format <colgroup><col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"><colgroup><col width="62" style="width: 47pt...

On my userform, a combobox change event is triggered when the user changes the value from the dropdown. If the user selects "Other", this code is executed: Private Sub uf1cbx1_operatorini_Change() If uf1cbx1_operatorini.Value = "Other" Then With uf1lbl1_name .Locked =...

Hello, So I'm really fresh on Excel VBA and I've no idea how to code in this language but I really need to get a work done. The task is to select an option from a combo box (let's say a day of the week) , enter your name,surname, and phones number, click a button and that should move everything...

I use VLOOKUP to bring a person's name from a database into a form. In the database the name always has the format of christian name(s) followed by surname. There can be 1, or 2, or however many christian names. The form requires that I enter surname in one cell and christian name(s) in a...

I have a column which contains first names and surnames in the cells. I want to extract the initials and the full surname from each cell. e.g. cell A1 will have Peter John Thomas which I want to convert to P J Thomas, cell A2 has Mary Jane Louise Wilson which I want to convert to M J L Wilson...

I have the following code to swap the order of names, buthave just noticed one strange problem. The names are formatted surname forename and I am swappingthem to forename surname. However if the surname is only 3 letters it does not swap,if I add an additional letter, or an extra space between...

Hi All, Trying to add worksheet names to a listbox based on a set criteria. The one line of code that doesn't work is. If Workbooks(filename).ws.Cells(7, 2) = "Surname" Then Not sure what it should be. ws is dimmed as worksheet 'I want worksheets added to the listbox only if cell(7,2) is...

Hi I need to split First and Last Names, removing any middle names as per the table below; <tbody> <tbody> A1 B1 Currently Becomes Walker Barbara Ann Barbara Walker Taylor Ron James Ron Taylor Clark Steve Steve Clark Price Kevin Liam Pat Kevin Price </tbody>...

I have a table of sports teams of which part of it has Captain, Player 1, Player 2, Player 3 etc. and currently has salutation (female only), first name, surname, I have duplicated this part of the sheet onto another sheet where I wish to have the names reversed i.e. surname first, and then...

Hello everybody. Suppose I have a list in range A5:A9 JOHN SMITH PETER PAN ROBIN HOOD MARK TWAIN ROD STEWART I've to put this list in alphabetical order for surname (may be in the cell we can invert name & surname, so JOHN SMITH could become SMITH JOHN). How could I? Thank's.

Hi all, I am trying to extract a surname from a text string, something like thisSmithTaxi. The array formula I am using (and shamelessly nicked off this forum)is below, I think the formula is extracting the characters up until there is anew capital letter in the string...

HI guys, I am struggling to get the function to work to find me the position of the 4th last space within a string from the right. String is like.. "Firstname Secondname Surname Myhome 23 8545 Westfield" but it also could be like "Firstname Surname Myhome 5 4524 Testinghof" Now I like to get...

I have a three tab spreadsheet. Tab 1 has ID - First name - Surname - Review Date Tab 2 has ID - First Name - Surname - Exit Date I want tab 3 to bring them both together so to speak ID - First Name - Surname - Review Date - Exit Date However the problem is that many of clients have the...

Data in column A. I want to split the data to 3 columns and flip the lastname with firstname. Lastname is ALWAYS capitalized. When firstname or/and lastname consists of 2 words then it can be in 1 cell. Look for example (2 BERNAL Egan Arley) beneath. Any help is appreciated. Data to change...