| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 40592 | 2003-12-12 01:49:00 | Excel sum problem | ecurb (3669) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 199718 | 2003-12-12 01:49:00 | Hi In Excel I have a column of data with text eg AA AB AA AB AC AB SC AD Question 1 - Is there an easy formula that tells me all the variations so I end up with a column that lists? AA AB AC AD SC Question 2 - Is there a formula that can tell me how many occurences of each variation so I get an answer like AA 2 AB 3 AC 1 AD 1 SC 1 I have done it years ago but can't figure it out now. Any help appreciated Regards Bruce |
ecurb (3669) | ||
| 199719 | 2003-12-12 02:20:00 | I used to be able to do that in Lotus, but don't know how Excel does it. Someone steered me to Mr Excel (216.92.17.166) a few months ago - you should find the answer there. :| | WalOne (4202) | ||
| 199720 | 2003-12-12 02:36:00 | See this page here (www.cpearson.com) on extracting unique items from a list. Once youve done that you can use CountIf to count the number of occurances. hth |
parry (27) | ||
| 199721 | 2003-12-12 03:46:00 | You can do it using a pivot table using the count function. | Big John (551) | ||
| 1 | |||||