Listing & Counting Problem
 

There are many ways of doing what you want to do. This is one:
Data Filter Advanced Filter Unique Records Only

Post back if you need some other ideas.

--
RyGuy


"Russell" wrote:

Hello,

I am working on a spreadsheet that contains about 150 rows of part numbers.
It is possible the rows could eventually range into the 1000s with several
hundred part numbers repeated several times.

What I am trying to do is to have 2 separate columns, one with the part
number listed only one time and the other with the number of times that part
number appears.

I understand how to make the number of times calculate using the countif
statement, but how do I get it to search the list of part numbers and extract
the number only once?

I appreciate your help!!!

Listing & Counting Problem
 

I got the function below on this DG a while back:

Copy/Paste into cell C1:
=IF(ROWS($1:1)<=COUNTA(A1:A20),INDEX(A1:A20,SMALL( IF(A1:A20<"",ROW(A1:A20)-MIN(ROW(A1:A20))+1),ROWS($1:1))),"")
Note: This is a CSE Function (when you enter the function in a cell, hit
Ctrl + Shift + Enter...not just enter). Change the ranges to suit your needs
(i.e., over 1000 if your range will eventually grow this large).

Enter into cell D1:
=COUNTIF(A1:A20,C1)

You can also try to use a PivotTable:
Data PivotTable€¦follow the prompts€¦

Cordially,
Ryan---


--
RyGuy


"Russell" wrote:

I tried that method and it didn't seem to work right, even though it sounds
like the most logical method...

"ryguy7272" wrote:

There are many ways of doing what you want to do. This is one:
Data Filter Advanced Filter Unique Records Only

Post back if you need some other ideas.

--
RyGuy


"Russell" wrote:

Hello,

I am working on a spreadsheet that contains about 150 rows of part numbers.
It is possible the rows could eventually range into the 1000s with several
hundred part numbers repeated several times.

What I am trying to do is to have 2 separate columns, one with the part
number listed only one time and the other with the number of times that part
number appears.

I understand how to make the number of times calculate using the countif
statement, but how do I get it to search the list of part numbers and extract
the number only once?

I appreciate your help!!!

Listing & Counting Problem
 

I tried that method and it didn't seem to work right, even though it sounds
like the most logical method...

"ryguy7272" wrote:

There are many ways of doing what you want to do. This is one:
Data Filter Advanced Filter Unique Records Only

Post back if you need some other ideas.

--
RyGuy


"Russell" wrote:

Hello,

I am working on a spreadsheet that contains about 150 rows of part numbers.
It is possible the rows could eventually range into the 1000s with several
hundred part numbers repeated several times.

What I am trying to do is to have 2 separate columns, one with the part
number listed only one time and the other with the number of times that part
number appears.

I understand how to make the number of times calculate using the countif
statement, but how do I get it to search the list of part numbers and extract
the number only once?

I appreciate your help!!!