enumeration of index page numbers

[depshado]

I have cells which contain text and page numbers from the index of a document.
I need to count the number of pages listed and remove duplicates from the total count.

any ideas?

[mikerickson]

= SUMPRODUCT(1/COUNTA(A1:A10, A1:A10)) will return the number of different entries in A1:A10. If there are blank cells in the region, that has to be adjusted for.

[Søren Larsen]

would this do the trick?

=SUM(IF(FREQUENCY(MATCH(array,array,0),MATCH(array,array,0))>0,1))

[depshado]

I will run both and see what happens

[depshado]

this = SUMPRODUCT(1/COUNTA(A1:A10, A1:A10))
produced a sum of the numbers as whole numbers as percentage.
Each number needs a value of one and any reduntant numbers need to be excluded

National Congress, 608,181-90
passim states, 27-28
Colonial era, 23, 27-38 passim, 43,

I also need to enumarate a range such as 27-38,
I would subtract the last page from the first page and add one to get the total count but this would not solve for duplicate entries

[depshado]

would this do the trick?

=SUM(IF(FREQUENCY(MATCH(array,array,0),MATCH(array,array,0))>0,1))

Array would be the cell:cell?

[Søren Larsen]

Array would be the cell:cell?

It would be the area in which you have your pagenumbers.

[depshado]

It would be the area in which you have your pagenumbers.

=SUM(IF(FREQUENCY(MATCH(E59,E60,0),MATCH(E59,E60,0))>0,1))
this produced
#N/A

are the values incorrect

[mikerickson]

Could you attach a sample workbook, showing the desired result.

Oh, I just noticed that silly me made an error
= SUMPRODUCT(1/COUNTIF(A1:A10, A1:A10))

[depshado]

Could you attach a sample workbook, showing the desired result.

Oh, I just noticed that silly me made an error
= SUMPRODUCT(1/COUNTIF(A1:A10, A1:A10))

three cell contain the following values
National Congress, 608
states, 27, 28
608,27,28, 80

The desired result would be a count of 4

the formula produce a count of 3
getting closer

[depshado]

would this do the trick?

=SUM(IF(FREQUENCY(MATCH(array,array,0),MATCH(array,array,0))>0,1))

=SUM(IF(FREQUENCY(MATCH(E59:E61,E59:E61,0),MATCH(E59:E61,E59:E61,0))>0,1))

this formula also produced 3 for total count
correct result should be 4

[mikerickson]

Why is a result of 4 desired, there are only 3 entries, none of which are duplicated.