Counting entries in a column

[Guest]

Hello everyone,

I have a sales forecast spreadsheet consisting of 1004 rows of data. Column 'G' contains the quote numbers associated with each record, which in some cases can be duplicated on a different row (different products on the same quote being recorded in the forecast individually).

I want to count all the unique quote numbers in the column, but omit the duplicates in order to get an idea of the true number of quotes without having to scroll to the end of the list to look at the last row number and subtracting known duplicates.

Any advice would be welcomed... Thx all.

 

[Paul B]

Cincode, here is one way, =COUNT(IF(FREQUENCY(G:G,G:G),1))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Hello everyone,

I have a sales forecast spreadsheet consisting of 1004 rows of data.

Column 'G' contains the quote numbers associated with each record, which in
some cases can be duplicated on a different row (different products on the
same quote being recorded in the forecast individually).

I want to count all the unique quote numbers in the column, but omit the

duplicates in order to get an idea of the true number of quotes without
having to scroll to the end of the list to look at the last row number and
subtracting known duplicates.

 

[Ron Rosenfeld]

Hello everyone,

I have a sales forecast spreadsheet consisting of 1004 rows of data. Column 'G' contains the quote numbers associated with each record, which in some cases can be duplicated on a different row (different products on the same quote being recorded in the forecast individually).

I want to count all the unique quote numbers in the column, but omit the duplicates in order to get an idea of the true number of quotes without having to scroll to the end of the list to look at the last row number and subtracting known duplicates.

Any advice would be welcomed... Thx all.

You could use the COUNTDIFF function in Longre's morefunc.xll free add-in

http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm#Morefunc.xll.


--ron