Use the Options button then Count. This gives you a list of the unique values and you can see how many there are.

Copying only the unique values from a set of cells in OpenOffice.org Calc spreadsheets. Select the column of. You'll get only the unique values from that. OpenOffice Calc has many ways for a user to add a column of numbers for a total. Adding via columns: 1. Type the numbers the user wishes to add, in the desired cells. Copying only the unique values from a set of cells in OpenOffice.org Calc spreadsheets. Select the column of. You'll get only the unique values from that.

Or, if all you need is the count and don't care what the unique values are, use =SUM(1/COUNTIF(X2:X99;X2:X99)) which must be entered with ⌘⇑Enter on a Mac or Ctrl+Shift+Enter on other platforms. If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title.

You can select the green checkmark icon at the same time. Download Project Management Gray Larson 4th Edition Software. Suppose we have a label in X1 and the rows have in X2:X12: 3 1 4 1 5 9 2 6 5 3 5Then =SUM(1/COUNTIF(X2:X12; X2:X12)) expands to the sum of 1/COUNTIF(X2:X12; X2), 1/COUNTIF(X2:X12; X3), 1/COUNTIF(X2:X12; X4), 1/COUNTIF(X2:X12; X5), 1/COUNTIF(X2:X12; X6),.

These COUNTIFs evaluate to 1/2, 1/2, 1/1, 1/2, 1/3, 1/1, 1/1, 1/1, 1/3, 1/2, and 1/3 with a sum of 7. Numbers which occur once contribute one 1/1, numbers which occur twice contribute two 1/2's, numbers which occur thrice contribute three 1/3's, etc. If you don't understand the array formula, don't use it. Instead put =1/COUNTIF(X$2:X$12;X2) in Y2, the formula down to Y12, and sum those values with =SUM(Y2:Y12).

Usb Storage Manager Apk File on this page. Most people find this method much easier to understand. Nokia 3110c Flashing Software. Read section 8. Using formulas and cell references in if you don't understand why there are two $ characters in =1/COUNTIF(X$2:X$12;X2).

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.