About 1,049,952 results (5,177 milliseconds)
Highlight duplicate names when last name, first name are in two ...
https://support.google.com/docs/thread/41751435/highlight-duplicate-names-when-last-name-first-name-are-in-two-separate-columns?hl=en Apr 22, 2020 ... I have used =COUNTIF($A$2:B,Indirect(Address(Row(),Column(),)))>1 but this highlights any duplicate last names within that column, rather than ...
Formula to flip the order of names only works part of the time ...
https://support.google.com/docs/thread/179262686/formula-to-flip-the-order-of-names-only-works-part-of-the-time?hl=en Sep 14, 2022 ... I get a spreadsheet at work with employee names on it. The names are listed in Last, First name order, and I need them in First Name Last ...
How do I sort by last name after exporting grades to Google Sheets ...
https://support.google.com/edu/classroom/thread/57744900/how-do-i-sort-by-last-name-after-exporting-grades-to-google-sheets?hl=en Jul 7, 2020 ... I have exported my grades to Google Sheets, however they are sorted alphabetically by first name. ... make sure that the students' names have been ...
Finding the SUM across multiple tabs based upon a name - Google ...
https://support.google.com/docs/thread/6558040/finding-the-sum-across-multiple-tabs-based-upon-a-name?hl=en May 21, 2019 ... First name in column A. Last name is column B. And you want to make column C have the names in Last, First style. Without arrayformula you ...
How to list all staff names that are contained in a list - Google Docs ...
https://support.google.com/docs/thread/82348915/how-to-list-all-staff-names-that-are-contained-in-a-list?hl=en Nov 11, 2020 ... Anyone filling out the form can write their name however, first name last name, just their last name, etc. ... In most cases you would only get ...
First Name, Last Name First Letter Extract - Google Docs Editors ...
https://support.google.com/docs/thread/117881155/first-name-last-name-first-letter-extract?hl=en Jul 20, 2021 ... I have tried several methods and I am not able to get the right formula. Kindly help on this. The Sample Sheet is attached here with for ...
FormulaArray not working as expected across different sheets ...
https://support.google.com/docs/thread/27189490/formulaarray-not-working-as-expected-across-different-sheets?hl=en Jan 30, 2020 ... 1st2nd3rd Totals (sheet 1)has the columns Form, Last Name, First Name, 1st Choice, 2nd Choice, 3rd Choice, BLANK COLUMN, 1st Choice Totals [ ...
How do I concatenate and copy text from two adjacent cells ...
https://support.google.com/docs/thread/4895603/how-do-i-concatenate-and-copy-text-from-two-adjacent-cells?hl=en Apr 25, 2019 ... Sheets,Microsoft ... first and last names. I again used an arrayformula so it only take one formula which I put in C2 of your Counts sheet.
Sort Multiple Sheets of Data at Once - Google Docs Editors Community
https://support.google.com/docs/thread/96514281/sort-multiple-sheets-of-data-at-once?hl=en Feb 3, 2021 ... I'd like the employee's first name, last name, and hire date, to be ... first sheet to make those columns rearrange on the other sheets.
Find all columns by name/heading? - Google Docs Editors Community
https://support.google.com/docs/thread/129340535/find-all-columns-by-name-heading?hl=en Oct 4, 2021 ... ... last name, and then first name. Is that what you need? Note that the ... formulas and I'd like to make it easier for her. But that ...
How do I create a lookup for emails based on a unique ID? - Google ...
https://support.google.com/docs/thread/16919181/how-do-i-create-a-lookup-for-emails-based-on-a-unique-id?hl=en Oct 15, 2019 ... If the record does not exist on the second sheet, I would like it to concatenate the first name, last name and id to create a "dummy" email ...
UNIQUE ImportRange by first and last name - Google Docs Editors ...
https://support.google.com/docs/thread/103438524/unique-importrange-by-first-and-last-name?hl=en Mar 22, 2021 ... These are array formulas that create their whole result table in one go. See the new Solution sheet in your sample spreadsheet for an ...
Dynamically Updating Worksheets from Master Sheet - Google Docs ...
https://support.google.com/docs/thread/105726370/dynamically-updating-worksheets-from-master-sheet?hl=en Apr 10, 2021 ... But they are simple info spreadsheets with no formulas and with headings across the top row (last name, first name, position, email, phone, ...
Adding a " " space to an ArrayFormula w/ a Concatenation - Google ...
https://support.google.com/docs/thread/113328378/adding-a-space-to-an-arrayformula-w-a-concatenation?hl=en Jun 12, 2021 ... I have two name fields (First Name & Last Name) and want to concatenate them using an ArrayFormula. My problem is that I can't figure out ...
google sheets, need to separate data from cells into new cells ...
https://support.google.com/docs/thread/138984708/google-sheets-need-to-separate-data-from-cells-into-new-cells?hl=en Dec 6, 2021 ... The columns giving me trouble have multiple lines in them such the first name, last name and email address. ... Excel format. All of the ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop For example, a column with "Last name, First name" can be split into 2 ... Cells with identical values but different letter cases, formatting, or formulas are ...
How to Create Emails from Name in sheets? - Google Docs Editors ...
https://support.google.com/docs/thread/13831788/how-to-create-emails-from-name-in-sheets?hl=en Sep 7, 2019 ... A script or formula that takes the name and automatically creates an email address using the formula {first}.{last}@apple.com.
Using vlookup to match a student's email on one sheet with their ...
https://support.google.com/docs/thread/116205355/using-vlookup-to-match-a-student-s-email-on-one-sheet-with-their-name-on-a-different-sheet?hl=en Jul 7, 2021 ... The 'Autofill name, section' sheet shows how to take the Form Responses data and insert the First name, Last name and Class section columns ...
which formula used for getting emails by first name, last name and ...
https://support.google.com/docs/thread/241789960/which-formula-used-for-getting-emails-by-first-name-last-name-and-website-in-domain-google-sheets?hl=en Oct 31, 2023 ... I need a google sheet that has the equation built into it so that when I put in first name, last name and domain it give me the email patterns.
How to split a full name into FIRST Name, MIDDLE Name and LAST ...
https://support.google.com/docs/thread/118184678/how-to-split-a-full-name-into-first-name-middle-name-and-last-name-in-google-sheets-using-formula?hl=en Jul 22, 2021 ... Can anyone please derive me an GOOGLE SHEETS formula to achieve the desired format "(DESIRED FORMAT)" of name as mentioned below from a default ...