2
Open "Microsoft Query"
three
Select the data source: EXCEL file * and uncheck "Use Query Wizard" to confirm.
Open the permutation and combination. The xls file is stored as an external data source on the computer's E: disk.
Add the employee $ worksheet to query and close it.
Click the SQL button in the query toolbar.
Fill in the following SQL statement:?
Select *
From [employee $] A, [employee $] B, [employee $] C.
A. Where are the staff?
Sort by? A. Staff B. Staff C. Staff
Click ok.
Wait a moment, and the system will display the permutations and combinations that meet the conditions.
Finally, select the "Return data to EXCEL" option under the query "File" menu.
The Import Data dialog box pops up. Click cell D 1 to confirm that the data has been imported into cell D 1, and then click OK. Of course, you can also put the results in a new worksheet.
Because of the large amount of data, there are 969 permutations and combinations, and EXCEL tables are frozen in the window.
Follow-up processing results and printing out lottery tickets.