 |
|
|
Group Summary: Summarize your data, by up to
three groups, in ascending or descending order.
Top/Bottom Items: Sort in ascending or descending order, and list
a group of the top or bottom items
Age: Take your dated information and group and total it according
to intervals you set.
Strata: Takes your data and splits it into bands that you define.
Get the totals and stats you need by the data groupings you want and
then chart if desired.
Duplicates: Find duplicates in your data and tag them. Once you
have them identified you can remove them, put them on a new sheet or
append them to an existing sheet.
Gaps: Specify a range in a column or group and then look for
items that spill over. Move them to a new sheet; append them to the
existing sheet.
Descriptive Statistics: Select a column, and get totals, averages,
standard deviations, variances, medians, mediums, max, and mins
|
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
FREE Excel Help