WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to generate random numbers in excel without duplicates

    53 results for how to generate random numbers in excel without duplicates

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    53 results for how to generate random numbers in excel without duplicates

    Insert Table of Figures and refer to the List of Captioned Objects

    Insert Table of Figures and refer to the List of Captioned Objects

    01:20

    Insert Table of Figures and refer to the List of Captioned Objects

    When there are too many pictures or tables inserted into a document, we can make a table of figures. It can generate a list of captioned objects and their page numbers for quick location. So how do we insert the table of figures? In this document, for example, we have inserted 6 images with captions.Click the location where we need to insert the table of figures, and click the Insert Table of Figures button on the References tab to get a dialog. On the left side of the dialog, we can ....

    Writer views

    How to remove duplicates in Excel

    · Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....

    Spreadsheet 0.1118 views
    Use the text function to extract characters in cells

    Use the text function to extract characters in cells

    02:45

    Use the text function to extract characters in cells

    In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

    Spreadsheet views
    Use Date function to convert date format

    Use Date function to convert date format

    01:50

    Use Date function to convert date format

    We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

    Spreadsheet 0.3086 views

    How to check for duplicates in WPS Office Excel sheets

    We often need to compare two sets of data and check for duplicates at work, but it would be a waste of time to look for duplicates one by one. To solve this problem, WPS Office provides the Manage Duplicates function. · Steps to check for duplicates with the Manage Duplicates functionHere we take two sheets as examples, which record the attendees of Conference 1 and Conference 2. To find out those who attended two conferences, we need to check for duplicates in these two sheets. 1. Hea....

    Spreadsheet views
    More features in Splitting Columns

    More features in Splitting Columns

    03:06

    More features in Splitting Columns

    When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns. Take this table as an example. In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Width to split columns manually. In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has t....

    Spreadsheet views
    Clear and avoid duplicates entries in WPS Spreadsheet

    Clear and avoid duplicates entries in WPS Spreadsheet

    01:56

    Clear and avoid duplicates entries in WPS Spreadsheet

    When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....

    Spreadsheet 0.2732 views
    More features in AutoFilter

    More features in AutoFilter

    02:39

    More features in AutoFilter

    When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....

    Spreadsheet views
    Prev 123...67 Next
    WPS Academy
    Products
    Partners