Select a blank cell besides the columns you will count unique rows says Cell E2 type the formula A2B2C2 into it and then drag the cells AutoFill Handle down to the range as you need. Enter the total number of objects n and number of elements taken at a time r 3. Select whether you would like to calculate the number of combinations or the number of permutations using the simple.
Active 5 years 6 months ago.
4And then click Ok button and a prompt box will pop out to remind you select a cell to. Select whether repeat elements. The formula is n n-12 where n is the number of items in the set. After that you simply enclose the formula in the ROWS function to calculate the number of rows.