Đề Xuất 10/2021 # How To Randomize A List In Excel: Sort Randomly Cells, Rows And Columns # Top Like

Xem 2,673

Cập nhật nội dung chi tiết về How To Randomize A List In Excel: Sort Randomly Cells, Rows And Columns mới nhất ngày 18/10/2021 trên website Lanbanhantoan.com. Hy vọng thông tin trong bài viết sẽ đáp ứng được nhu cầu ngoài mong đợi của bạn, chúng tôi sẽ làm việc thường xuyên để cập nhật nội dung mới nhằm giúp bạn nhận được thông tin nhanh chóng và chính xác nhất. Cho đến nay, bài viết này đã thu hút được 2,673 lượt xem.

--- Bài mới hơn ---

  • How To Randomly Sort A List In Excel
  • How To Generate Random Value From A Given List In Excel?
  • Excel Formula: Random List Of Names
  • Hướng Dẫn Cách Chọn Tên Ngẫu Nhiên Trong Excel Đơn Giản Nhất
  • Cách Sắp Xếp Ngẫu Nhiên Nội Dung Của 1 Cột Trong Excel
  • The tutorial will teach you two quick ways to randomize in Excel: perform random sort with formulas and shuffle data by using a special tool.

    Microsoft Excel provides a handful of different sorting options including ascending or descending order, by color or icon, as well as custom sort. However, it lacks one important feature – random sort. This functionality would come in handy in situations when you need to randomize data, say, for an unbiased assigning of tasks, allocation of shifts, or picking a lottery winner. This tutorial will teach you a couple of easy ways to do random sort in Excel.

    How to randomize a list in Excel with a formula

    Although there is no native function to perform random sort in Excel, there is a function to generate random numbers (Excel RAND function) and we are going to use it.

    Assuming you have a list of names in column A, please follow these steps to randomize your list:

    1. Insert a new column next to the list of names you want to randomize. If your dataset consists of a single column, skip this step.
    2. In the first cell of the inserted column, enter the RAND formula: =RAND()
    3. Excel RAND formula

      Sort the column filled with random numbers in ascending order.

    Either way, Excel automatically expands the selection and sorts the names in column A as well:

    Names are sorted in random order.

    Tips & notes:

    • Excel RAND is a volatile function, meaning that new random numbers are generated every time the worksheet is recalculated. So, if you are not happy with how your list has been randomized, keep hitting the sort button until you get the desired result.
    • To pvent the random numbers from recalculating with every change you make to the worksheet, copy the random numbers, and then paste them as values by using the Paste Special feature. Or, simply delete the column with the RAND formula if you don’t need it any longer.
    • The same approach can be used to randomize multiple columns. To have it done, place two or more columns side by side so that the columns are contiguous, and then perform the above steps.

    How to shuffle data in Excel with Ultimate Suite

    If you don’t have time to fiddle with formulas, use the Shuffle Cells tool included in our Ultimate Suite for Excel to do a random sort faster.

      Shuffle Cells tool in Excel
    1. The Shuffle pane will appear on the left side of your workbook. You select the range where you want to shuffle data, and then choose one of the following options:
      • Cells in each row – shuffle cells in each row inpidually.
      • Cells in each column – randomly sort cells in each column.
      • Entire rows – shuffle rows in the selected range.
      • Entire columns – randomize the order of columns in the range.
      • All cells in the range – randomize all cells in the selected range.

    In this example, we need to shuffle cells in column A, so we go with the third option:

    Shuffle cells in the selected columns.

    And voilà, our list of names is randomized in no time:

    A list of names is randomized.

    If you are curious to try this and explore a lot more fascinating features included with Ultimate Suite for Excel, you are welcome to download a 14-day trial version.

    You may also be interested in

    --- Bài cũ hơn ---

  • Những Phím Tắt Hay Dùng Trong Excel, Dân Văn Phòng Không Nên Bỏ Qua
  • 99 Phím Tắt Trong Excel
  • How To Use The Excel Roundup Function
  • Hàm Chia Lấy Số Dư Mod Và Chia Lấy Số Nguyên Quotient Trong Excel
  • Join Two Or More Tables In Excel With Power Query
  • Bạn đang đọc nội dung bài viết How To Randomize A List In Excel: Sort Randomly Cells, Rows And Columns trên website Lanbanhantoan.com. Hy vọng một phần nào đó những thông tin mà chúng tôi đã cung cấp là rất hữu ích với bạn. Nếu nội dung bài viết hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất. Chúc bạn một ngày tốt lành!

  • Web hay
  • Guest-posts
  • Chủ đề top 10
  • Chủ đề top 20
  • Chủ đề top 30
  • Chủ đề top 40
  • Chủ đề top 50
  • Bài viết top 10
  • Bài viết top 20
  • Bài viết top 30
  • Bài viết top 40
  • Bài viết top 50