Home |
Search |
Today's Posts |
#1
|
|||
|
|||
showing the # of times an item is entered in a column
This involves Excel 2003. We have an Excel file with thousands of
records(rows) and one of the fields(columns) is called PRODUCT ID. There are many, many different PRODUCT ID numbers that can be entered into the column. I would like to see how many times each PRODUCT ID number is entered in the file. What I want is some kind of list showing each PRODUCT ID number along with the count. For instance: PRODUCT ID COUNT A12345 014 A56789 056 B83741 132 C28294 089 etc. etc. etc. down to the last number in the file Y73958 105 Z43002 043 Is there a way to get these counts for a column in a file?? Thank You Very Much |
#2
|
|||
|
|||
Try Data-Subtatals
and select count at each change in ProductID You need to sort your file on ProductID first "Foreplay_Man" wrote in message ... This involves Excel 2003. We have an Excel file with thousands of records(rows) and one of the fields(columns) is called PRODUCT ID. There are many, many different PRODUCT ID numbers that can be entered into the column. I would like to see how many times each PRODUCT ID number is entered in the file. What I want is some kind of list showing each PRODUCT ID number along with the count. For instance: PRODUCT ID COUNT A12345 014 A56789 056 B83741 132 C28294 089 etc. etc. etc. down to the last number in the file Y73958 105 Z43002 043 Is there a way to get these counts for a column in a file?? Thank You Very Much |
#3
|
|||
|
|||
Try this 1.Select the complete table. go to data - sort select "sort by" product id - click ok. 2. Select the complete table. go to data -subtotal- at each change in "select product id". use function "select count" , add subtotal to "select count". - click ok. You should be able to see each product id with its count. -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277028 |
#4
|
|||
|
|||
Insert a "helper" column next to the product ID column, and enter this
formula: =COUNTIF(A:A,A1) Now, select the cell with this formula, and *double* click on the "fill handle', which will *automatically* copy the formula down the column, as far as there is data in the adjoining column. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Foreplay_Man" wrote in message ... This involves Excel 2003. We have an Excel file with thousands of records(rows) and one of the fields(columns) is called PRODUCT ID. There are many, many different PRODUCT ID numbers that can be entered into the column. I would like to see how many times each PRODUCT ID number is entered in the file. What I want is some kind of list showing each PRODUCT ID number along with the count. For instance: PRODUCT ID COUNT A12345 014 A56789 056 B83741 132 C28294 089 etc. etc. etc. down to the last number in the file Y73958 105 Z43002 043 Is there a way to get these counts for a column in a file?? Thank You Very Much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Returning the last item in column | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
How do I count how many times x appears in a column? | Excel Worksheet Functions |