Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GROUP
Hello,
I am looking for a function similar to the SQL function GROUP BY in excel. Basically what I want to do is make a list of all the unique variables in a list. After that I want to use the COUNTIF function to make a frequency table. Thus from the list: a b a c a c I want to get the list a b c Only the unique variables. I am surprised that EXCEL doesn't have a pre-defined function for this. Anyone knows how to do it? Jochem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Get the name of a group given the reference to a shape within the group | Excel Programming |