We get the output as shown below. There is another way we can create a list of values in excel, i.e., through named ranges in excel Named Ranges In Excel Name range in Excel is a name given to a range for the future reference. Find a Excel Product list template under the page which is free to download. for example in the scenario below, that order can be like this (start from zero on the left side). Low carb foods shopping list. In Excel 2007, save the workbook as a macro-enabled workbook that is named C:\Abc.xlsm. Go to click Formula > Name Manager, see screenshot: 2. Start with your current and past customers. Instead of making up nonsense all the time, I have a list of first names, a list of last names, and a list of addresses (split into columns). A list of defined names and their formulas is pasted into the worksheet. Say you have data in two columns in Excel. Excel | Word | PDF. . For users who are struggling with handling Microsoft Excel when trying to copy the same name multiple times without making it confusing, a simple procedure needs to be followed in order to count a list of names. QuickNamesList Macro Code. And besides that, we have a section where we will be looking up the value from the first table. When creating and using your client list template, there are several things to keep in mind: . Specify number of cells you want to select in the No. The first solution to use for the problem above is that you can use the index of the sheet, which means the order of the sheet among other sheets. I always confirm my range naming has been successful: Open the list of range names in the Name Box. Type "=" (Equal) sign to go in edit mode of that cell. You should see a decimal (e.g., 0.5647) appear in your selected cell. Step 3: Add the anonymous code. Download 40 KB #28. Press "Enter," and a random number will appear in the cell. Once each row contains a random number, sort the records by Random_number column. Now select the First name, then insert the "&" (Ampersand) sign and then select the Last name. The larger the list, the less probable there will be duplicates in the extracted list.) After the reception you can use the guest list to write the thank you notes to . This step by step tutorial will assist all levels of Excel users to learn how to randomly generate words in Excel. If you wear specs because of cylindrical power and all these list templates designed in excel sheets with too many rows and columns give you a headache then we have the perfect lists for you, specially designed in word. Download 127 KB #29. Press Enter to cement the range name in place —. This template will help you catalogue your software, keep track of your software licenses, registration numbers, user names, passwords and Internet addresses. In the Defined Names group, click Use in Formula, and click Paste Names (the keyboard shortcut is F3) In the Paste Name window, click Paste List. The generic formula for the RANDBETWEEN function is: If you're using Excel 2013 or earlier, follow Power Query > From File > From Folder in the Ribbon. On the keyboard, press Ctrl + C to copy the data. Once you're done, the column beside the "Sample Names" should now be filled with random numbers from 0 to 1. Select the cell with the random sample number. Explore premium templates. The Excel Product . ; Here, "Overview" is the first sheet in the workbooks and "Cleaning" is the last. Try to sort, filter, switch pages or change the number of displayed rows in the table to see how the report adjusts. Scroll down to the end of the sample data table. On the Formulas tab, in the Define Names group, click the Define Name. Enter SheetNames into the Name field, enter the following formula into the Refers to field: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),""), and then select OK.This action will create a named formula that can then be used in conjunction with the INDEX function to produce a list of worksheet names. Press ↵ Enter. Sheet Index. If you do get a duplicate name, then simply force a recalculation of your worksheet by pressing . To create a Named Range for the sheet names, in the Excel Ribbon: Formulas > Name Manager > New. Syntax of the RANDBETWEEN Formula. Summary. On the Excel Ribbon, click the View tab. Create Name Range for Sheet Names. 2. Method 2. On the Excel Ribbon, click the Formulas tab. You can even insert your company logo to personalize your product list. A wedding guest list will help you keep track of the invites, the RSVP's, the guest who attend the wedding, their gifts and anything that you want to be included. Type_num 1 returns the list of sheet names and that's what we'll be using. 2 Doug. Step 3: You will find a Drop-Down List in the Food Types column. Assign rw to a random number between 3 and 12 (the row numbers of your names). Keyboard shortcut Shift+Ctrl+End. STEP 2: Go to Home > Find & Select > Go To Special or simply press keys Ctrl + G and Select Special to open the Go To Special dialog box. This product price list template is editable in all older and newer versions of Microsoft Excel and is designed with editable elements. All you have to do is go to the 'Student Input' tab and paste in the names of your students. In the Sort/Select Range Randomly dialog box and under the Select tab, please configure as follows. the names on your Excel customer database template won't be much of a help. A list of names in a report may be generated, where the same name appears multiple times. You can see a list of files in the folder you selected and its sub-folders. Then drag fill handle down to fill this formula to cells you use. Fill in the column headings: . Firstly, you need a helper column to list some random data next to your data. Select any cell in your table. Step 1: Open Data Validation option. Add a new column within the spreadsheet and name it Random_number. Syntax of the RANDBETWEEN Formula. Step 1. count days in excel 18. The crux of this solution is the GET.WORKBOOK function which returns information about the Excel file. Download the Excel Random Student Name Generator by clicking below: Excel Random Student Name Generator. See this dummy exam results Excel report. In the Refers To box, check the reference and correct it if needed; Click OK to save the changes and close the dialog box. In the Scope dropdown, set the name scope ( Workbook by default). This current template allows for a list of up to 300 student names. Next is a preview window. For a sports team, keep track of player names, parent or guardian details, and contact information. Example: Doug buys 3 tickets and Mike buys 5 tickets. Suppliers name > Contact number > supplier type > Key Grade. 141 Free Excel Templates and Spreadsheets. Make an address list Overview (A step by step guide follows) Print out the spreadsheet and hand it in. Open both the customer list template AND the invoice or work order template that you are wanting to copy to. Using VBA Get a List of All the File Names from a Folder. (The improbability comes because of the size of the original list. To paste a list of workbook level names in Excel: Insert a blank worksheet. Winter holiday party checklist. Here's how I picked the winner: In cells A1:B1, enter the headings, Name and Number, and format those cells as Bold. In the example shown, the formula in B5 is: Note: I ran into this formula on the MrExcel message board in a post by T. Valko. Click OK. Excel creates a worksheet for each worksheet name in your list. It is important to realize that at this point each of the new worksheets contains a small PivotTable. See Figure 3.5 for an example of how a list appears after you've used the Create List com-mand. You want to just click the down-arrow.) Formula to Dynamically List Excel Sheet Names. It is possible, but not probable, that you will get the same name twice in the resulting list. Type "Worksheets" in the Name Box: Copy the Customers Sheet into your Workbook. As you click on the option, a dialogue box would open with a blank space to fill in with the file's name. In the column I, we'll add the code that will replace the original names. For this, we have sales data as shown below. When a person responsible for choosing a supplier took a decision taking in regard to all the factors then he can easily contact the chosen supplier. Cells(3, 4) = Cells(rw, 3) Cells(3 (3rd row), 4 (4th column)) is the same as Range("D3") - where you want your random name. STEP 3: Select Row Difference and Click OK. And, Voila! Step 2: Block the area (the cells that are filled with names) and give it a name as shown in . Excel displays the Show Report Filter Pages dialog box. In the Name box, type the range name. Select the QuickNamesList macro in the list, and click the Run button. Event Budget Template. Word. Go to the office button and select the option save as. See screenshot: 2. Close the workbook and quit Excel. How it Works. Step 4: Now select all the datasets and click on Create from Selection option under the Formulas tab. Excel allows us to get a random number from a range using the CHOOSE and RANDBETWEEN functions. ; Then the INDEX and ROW Functions display each value in that array. In Excel, you can define a range name, and then apply a formula to list all sheet names from current workbook, please do with following steps: 1. Press Start / Program / Microsoft Excel (and you may need to first select Microsoft Office). List all the fan names in column A, under the column heading "Name". It consists of supplier names as well as their contact information. Of . Other data sets - Sales Credit Card Bank Transactions HR Analytics Note - I have been approached for the. Is there a formula for another type of rotating list that will accomplish the following: When "Y" or "N" are entered into column G, then row is moved to the bottom of the list. After that, copy and paste the syntax down the column. In Excel 2003 and in earlier versions of Excel, save the workbook as C:\Abc.xls. When the next entry comes up the Y or N is changed to an "A." The spreadsheet is never reset, it is on-going from day to day. Bring your ideas to life with more customizable templates and new creative options when you subscribe to Microsoft 365. Disclaimer - The datasets are generated through random logic in VBA. Similarly, templates for Excel spreadsheet(s) can also help you with short and long-term budgeting. Add this code to a regular code module in your workbook, and to run the code, follow these steps. In Visual Basic 6.0, create a new Standard EXE project. Navigate to the folder you want to extract file names from. It is not possible to remember all the names of the bio-chemical, organic or the other physical . Put a name to the file and click on OK. The result then becomes. So whether it be a class list, contact list, or even sales list, it's important that you know what it should consist of and what you should do in order to make it. I want Excel to automatically update the number list based on the quantity of tickets each associate paid for. Now that you know the sheet index, you can . A basic template for this is prepared in Microsoft excels. As you . And click Kutools > Select > Select Range Randomly. Create a Formula to list all sheets; If you want to use a formula, follow these steps: Create a named range "Worksheets" Use a formula to list out all sheet names. Make sure to check the "Create a Copy" checkbox. The final result of the formula. Download 12 KB #27. You can also type in as many products in the list table, so you can be sure . Free Excel templates take the stress away from having to remember whose turn it is to clean the bathrooms or wash the dishes. Type (dir /b > "sample.txt") minus the parenthesis. Choose File / New / Workbook to create an empty Excel spreadsheet. 3 60 Chapter 3 Excel's Lists,Names,and Filters Figure 3.5 When you add a new value in any column in row 22,Excel expands the border and moves the insert row. 'Generate a . The more names you add to this list, the more your business grows. Example #2 - Count Name which has Some Common String. If you're looking for Excel templates to use at home, consider a weekly chore schedule or household to-do list. In the Refers to box, check the reference and correct it if needed. How to count names in Excel: formula, using COUNTIF. The raffle list now looks like: 1 Doug. To create a random list of names, you can use the INDEX function and the RANDARRAY function to select random names from an existing list. Listing A. Sub ListSheetNames () 'List all sheet names in column A of Sheet1. Select the cell (s). You can expand the list directly by clicking and dragging the resize handle in the bottom- Continuing, let us assume you have 25 named worksheets. Drag the applied formula in all the cells below. To name a range, first select the range of data and then insert a table to the range, then put a name to the range from the name box on the left-hand side of the . Click OK when you have the target selected. Browse Templates. Then, with the fill-handle, we just have to drag down to automatically increase the series of numbers . The generic formula for the RANDBETWEEN function is: Step 5: Finish the Template and save the file. In this example, we will see the way to name the table used in the Vlookup function. The Best Way to Organize Contacts in Excel. Summary of Example #1: As the user wants to calculate the count of the name, which has age data in the table.So, 6 names in the above example have age data in the table. You can use this template as a team roster, sports sign-up sheet, or contact list. Step 2: In the Data Validation window, select Allow as List and Select the Source as below. ActiveSheet.Cells (1, 1).Select. If you want to generate random groups for a list of data, and each group has a specified data size, you can use the ROUNDUP and RANK functions. Answer (1 of 6): I create sample files pretty regularly, for which I need to have a list of random names. Select the cell (s). In the example shown, the formula in B5 is: Note: I ran into this formula on the MrExcel message board in a post by T. Valko. Excel Customer Database Templates. 1. Solution 1: Use Sheet Index Not the Name. These data files are of super high quality.If you are developing software and want to test it, you will need sample data for this. Download Excel | Try Smartsheet. Supposing in cell E2, type this formula. It is enclosed in square brackets because it is a worksheet function, not VBA. This step by step tutorial will assist all levels of Excel users to learn how to randomly generate words in Excel. Using the radio button and the 'copy-to' options, it is required to choose the 'unique records only' option to solve this. It also works well for clubs or other groups. #3 - Create List through Named Manager. To change the cells to values, select all the cells with formulas . Figure 1. In the first cell underneath your heading row, type "= RAND ()". Copy and paste the first cell into the other cells in this column. These are people who have clearly "opted in" to your services, and you can likely find their contact information rather quickly. Click the Select button. Sheets ("Sheet1").Activate. To start, enter the 'RAND' syntax into the cell beside the first entry of our list. Now, I must say that the above method is a bit complex (with a number of steps). In the Name Box at the left-hand end of the Formula Bar, replace A2 with the input nmFirstNames. You can use AutoFill, by double-clicking, to populate cells based on the adjacent columns (non-blank columns to the left and right of the . The formula above takes the "Worksheets" array and displays each sheet name based on its position. Summary: This article describes how to create mass letters from Excel, using a Microsoft Word Document as the letter template and a Map between Excel Defined Names and Word Document Bookmarks.. Thoughts… Starting from the example described in this article, there are numerous things that can be done: if we setup the same bookmarks in Multiple Word Documents, and if we use a multi-select . This Product Price List Template for Excel contains one table where you can list down all your product details. The Best Way to Organize Contacts in Excel. Weight loss do's and don'ts checklist. Re: Formula to rotate a list of names. Click at the end of the text heading above the table. Speak to your sales team about any lists they may have in their possession as well. Step 1: Fill the list of names that you have in any column without worrying about the order. In the Scope drop-down, set the name scope (Workbook by default). Paste it into an Excel workbook (Ctrl+V), for use in your own tests. Step by Step Guide: Create a new Excel spreadsheet. The "RAND" command applies a number between 0 and 1 to your selected cell. Watch Video - Get List of File Names from a Folder in Excel. Figure 1. Create a Visual Basic application to list the macros in the workbook. To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define a named range called "sheetnames" with an old macro command and (2) use the INDEX function to retrieve sheet names using the named range. Wedding guest list template is a tool that will help you build a wedding guest list. Microsoft Excel is a very powerful software that can be used to analyze and interpret large amounts of data in seconds. Right-click on the Customers tab and select "Move or Copy". Plan for your next event with this budget template that enables you to document and track your spend in categories, like staffing, marketing, travel, and more. The MID and FIND Functions extract the sheet names from the array (removing the workbook name). In the Name Manager dialog box, click New button, see screenshot: 3. To create data with random names, I simply creat. To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define a named range called "sheetnames" with an old macro command and (2) use the INDEX function to retrieve sheet names using the named range. These are not real human resource data and should not be used for any other purpose other than testing. The template is simple to use. In the example shown, the formula in D5 is: = INDEX( names,RANDARRAY(10,1,1,COUNTA( names ),TRUE)) which returns 10 random values from the named range "names" (B5:B104). The syntax is: =GET.WORKBOOK ( type_num, name_text) type_num refers to various properties in the workbook. Download Now. Excel allows us to get a random number from a range using the CHOOSE and RANDBETWEEN functions. In Column C, there are names, while in Column B, you want to assign a number to each name, i.e., make a list of numbers in Column B. Double-Click the Fill Handle. Sub QuickNamesList () Dim lRsp As Long If Selection <> "" Then lRsp = MsgBox . Highlight the list of names you want to select randomly. Here is the collecion of raw data for excel practice.Just click the download button and start playing with a Excel file. . With column 'A' having a list of names, where the same name is repeated, and the user desires . 'Update to change location of list. The final result of the formula. This time I offer you one more list as Excel template. With this issue, it is required to use the Filter and Advanced Filter options from the Data menu dropdown list. Once done, press the Enter key. At the far right, click Macros. One can save the edited copy of Excel Product list template in computer to make more product lists in near future. On the Formulas tab, in the Define Names group, click the Define Name button. In cell B2, type a RAND formula: =RAND () Copy the formula down to the last row of data. It start with a heading, where you can put your company name and contact information. Specify the number or percentage for the desired sample size. . 1. List Template Sample. Word. Start with your current and past customers. In the New Name dialog box, specify three things: In the Name box, type the range name. Example #1. 59+ FREE LIST Templates - Download Now Adobe PDF, Microsoft Word (DOC), Excel, Google Docs, Apple (MAC) Pages, Microsoft Publisher, Apple Numbers. Word. Identify resource costs and plan an amount to budget for each area to keep your event on track and within budget. I'm trying to make a raffle list for our office raffle in Excel. We have listed good quality test data for your software testing. 101 BEST EXCEL TIPS & TRICKS E-BOOK! Facebook page opens in new window Twitter page opens in new window Instagram page opens in new window YouTube page opens in new window 8:39 AM Countries List , Countries List Excel , Country List excel , List of Countries , National List Excel , Nationalities and Code Excel Edit Download JSON file for this List - Click on JSON file Press Shift, and click at the end of the last number in the table, to select all the data. Select the whole "RAND" column by clicking on the column header (C). However, the user name is not always important for the software catalog; Adobe software is directly connected to a user name or e . Go to the Ablebits Tools tab > Utilities group, and click Randomize > Select Randomly: On the add-in's pane, choose what to select: random rows, random columns or random cells. Address as well as fax number is also included. of cells to select box; Choose Select random cells option in . It can further be used to track budgets, expenses, create invoices, financial reports, checklists, calendars, and much more. If Excel attempts to automatically format your "RAND" command, delete the formatting and re-type the command. Speak to your sales team about any lists they may have in their possession as well. We'll just write in the I2 cell NAME001 value. Instructions for Setup. These are people who have clearly "opted in" to your services, and you can likely find their contact information rather quickly. Choose the Show Report Filter Pages option. Let's assume a user has some people's personal data like Name and Age, where the user wants to calculate the count of the name which has "Jr." string common in . This table has Owner, Quantity Sold and Product Class columns. That's why this article is . All the values in Stock List 2 that do not match with the corresponding value in Stock List 1 have been highlighted. This will create a text . Download Sports Team Contact List Template. Enter the main folder of your files either by typing its name or using Browse. > Product price list template for Excel practice.Just click the View tab the original names increase series... Office button and start playing with a heading, where you can be sure cells below purpose... Your workbook, and click on create from Selection option under the select tab, in cell. Code that will replace the original names Excel formula: =RAND ( ) copy the formula Bar, replace with. Names of the original list. Choose file / New / workbook to create data with names. - sales Credit Card Bank Transactions HR Analytics Note - I have been highlighted then, with the input.. Wash the dishes > step 1: fill the list of all the datasets click. It start with a Excel file 0.5647 ) appear in your list., or contact list. logo personalize! Sample.Txt & quot ; this article is which returns information about the Excel Ribbon, click button... To click formula & gt ; select range randomly dialog box, check the & quot.! Sample.Txt & quot ; RAND & quot ; name & quot ; Enter, & ;. Spreadsheet templates | Smartsheet < /a > example # 1 formula down to the folder you want to randomly. New button, see screenshot: 3 name which has Some Common String a regular code module in own! Get a duplicate name, then simply force a recalculation of your files either by typing its name or Browse! Can see a decimal ( e.g., 0.5647 ) appear in your selected cell in square brackets because it not... Open the list of names in the table, so you can worksheet by pressing of sample list of names in excel in... Of tickets each associate paid for format your & quot ; command, delete the formatting re-type! To 300 student names workbook ( Ctrl+V ), for use in your own tests also you. Worksheets contains a sample list of names in excel PivotTable ).Activate be using budgets, expenses, create a New Standard EXE.! The select tab, in the Refers to box, specify three things: the... Customer database template won & # x27 ; ts checklist cells that are filled with ). File names from the data box ; Choose select random names from a list the!, let us assume you have in their possession as well as sample list of names in excel number also! ; Enter, & quot ; create a New Excel spreadsheet in Stock list 2 that do not match the... The Vlookup function you can this template as a team roster, sports sign-up sheet, or contact.! File names from a folder run button Enter the main folder of worksheet! With the input nmFirstNames further be used to track budgets, expenses, create a New EXE! To 300 student names the Formulas tab, in the I2 cell NAME001.. Is designed with editable elements drag fill handle down to fill this formula to cells want! Food Types column the column number is also included Vlookup function percentage for the desired sample.. Stress away from having to remember all the cells to select randomly or contact list ). Random number will appear in your selected cell using COUNTIF the data, that order be... From Selection option under the Formulas tab will see the way to name the table to see how the adjusts! Near future //exceljet.net/formula/list-sheet-names-with-formula '' > Dynamically list Excel sheet names • my Online Training Hub < /a #. Have listed good quality test data for Excel spreadsheet named Manager your files either by typing its name or Browse! For your software testing ; Update to change location of list. track player. Can save the workbook: & # x27 ; ts checklist copy to, you need a column. That you are wanting to copy to cell underneath sample list of names in excel heading row type! You notes to the reference and correct it if needed we have sales data as shown below ( removing workbook! Complex ( with a number of displayed rows in the Sort/Select range randomly dialog box and under the column,... The MID and FIND Functions extract the sheet INDEX, you need a helper to! When creating and using your client list template for Excel - Vertex42.com < /a > step 1: the... Identify resource costs and plan an amount to budget for each area to keep your event track... Excel displays the Show report Filter pages dialog box and under the column header ( C ) returns about... Code to a regular code module in your selected cell step by step tutorial will all. 1 returns the list of names that you are wanting to copy data! > step 1 select row Difference and click OK. Excel creates a worksheet for each worksheet name place. Column heading & quot ; name the table used in the Refers to box, type range! Force a recalculation of your worksheet by pressing the number list based on the Quantity of each. Is not possible to remember whose turn it is not possible to whose! Quality test data for Excel - Vertex42.com < /a > example # 1 //www.extendoffice.com/documents/excel/2768-excel-select-random-names.html >... Sort the records by Random_number column option save as change the cells with Formulas a bit complex ( with Excel! Code to a regular code module in your own tests start playing with a Excel file data. Heading row, type a RAND formula: list sheet names and that & # x27 ; Update change! List the macros in the name Scope ( workbook by default ) have in their possession as.. The column heading & quot ; ).Activate this current template allows a. Then drag fill handle down to fill this formula to cells you.! Name which has Some Common String, let us assume you have in possession... Fill-Handle, we just have to drag down to automatically Update the number of displayed in! # 92 ; Abc.xlsm dropdown list. ) type_num Refers to various properties in the name box type! May have in their possession as well as fax number is also included range naming has successful! By clicking on the Formulas tab, please configure as follows click New button, screenshot. Or copy & quot ; automatically format your & quot ; sample.txt & quot ; you may to... List as Excel template < /a > # 3 - create list named! Click on create from Selection option under the select tab, please configure as...., in the table used in the I2 cell NAME001 value drag down to automatically Update the of... ; checkbox to the office button and select the Source as below financial reports checklists! '' https: //www.myonlinetraininghub.com/dynamically-list-excel-sheet-names '' > 32 free Excel templates take the stress from... //Www.Extendoffice.Com/Documents/Excel/2768-Excel-Select-Random-Names.Html '' > how to randomly generate words in Excel of tickets each associate paid for header C!, so you sample list of names in excel be like this ( start from zero on the,! The option save as it a name as shown in template and save the.... - I have been highlighted Food Types column and Mike buys 5 tickets | Exceljet < /a > example 1... Press start / Program / Microsoft Excel ( and you may need first! Excel is a tool that will replace the original names step 2: in No... Be like this ( start from zero on the Formulas tab with Examples sample data table ) copy the menu! Card Bank Transactions HR Analytics Note - I have been approached for the desired sample size the... Quality test data for your software testing I must say that the above method is a very software! Cell B2, type the range name other data sets - sales Credit Card Bank Transactions HR Analytics -! Set the name Scope ( workbook by default ) this Product price list template the. - FPPT < /a > example # 2 - Count name which has Some Common String be! A href= '' https: //www.educba.com/count-names-in-excel/ '' > Excel formula: list sheet names from sheets ( & quot Enter...: //www.smartsheet.com/32-free-excel-spreadsheet-templates '' > Product price list template is a bit complex ( with Examples ) EDUCBA! Now that you have 25 named worksheets Smartsheet < /a > example # 2 - name! ( start from zero on the Customers tab and select & gt ; name & ;! Track and within budget EDUCBA < /a > 1 create data with random names, parent guardian. Assist all levels of Excel users to learn how to randomly generate words in Excel gt name. Names in column a, under the Formulas tab, please configure as follows Excel - FPPT /a. Open both the customer list sample list of names in excel, there are several things to keep in:! ( start from zero on the Customers tab and select the option save.! List and select the QuickNamesList macro in the Define name button ;.. For this, we & # x27 ; s and don sample list of names in excel # x27 s! Copy and paste the syntax is: =GET.WORKBOOK ( type_num, name_text ) type_num Refers various...: Finish the template and the invoice or work order template that you know sheet. ; command, delete the formatting and re-type the command the macros in the,. To Dynamically list Excel sheet names and that & # x27 ; ts.. The run button parent or guardian details, and much more of range names in a. Now, I simply creat with editable elements of a help you can this. In computer to make more Product lists in near future this example, we just to... Test data for Excel practice.Just click the download button and select the option save as your quot! By default ) 101 BEST Excel TIPS & amp ; TRICKS E-BOOK # 2 - Count name has.