If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Number of items in a colum
Hei,
I would like to found out how many same items are in one Excel column. If the column has the values 1 3 4 2 5 6 7 9 3 6 7 8 3 the funktion should pic up the information that only ones there are items 1 4 2 5 9 8, twice there are items 6 7 and three times item 3. Thank you, Matti |
#2
|
|||
|
|||
Number of items in a colum
Assuming your data is in column A.
In B1, enter: =COUNTIF(A:A,A1) Then drag down thru B14 That will show you the number of occurences of each number. HTH -- AP * a écrit dans le message de news: ... Hei, I would like to found out how many same items are in one Excel column. If the column has the values 1 3 4 2 5 6 7 9 3 6 7 8 3 the funktion should pic up the information that only ones there are items 1 4 2 5 9 8, twice there are items 6 7 and three times item 3. Thank you, Matti |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update a number field incrementally | AllyOop | Running & Setting Up Queries | 7 | February 22nd, 2006 12:38 PM |
page number positioning and format | tinaa | Page Layout | 3 | February 4th, 2006 12:38 AM |
Report with set number of rows per page | Ken from Chicago | Setting Up & Running Reports | 7 | January 4th, 2006 02:42 PM |
Report with set number of rows per page | Ken from Chicago | General Discussion | 7 | January 4th, 2006 02:42 PM |
Help to append flat file table to two tables | Victoriya F via AccessMonster.com | Running & Setting Up Queries | 11 | September 26th, 2005 05:30 PM |