Look at these:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike Smith" wrote:

I unfortunately know nothing about pivot tables. I will have to read up and
see how to create one. I tried the wizard a couple times but it says the data
field is invalid.

"Carlos Mallen" wrote:

Hi,

Have you tried pivot tables? I think it is the tool that best fits your
needs. With pivot tables you can filter the data the way you are saying.

Regards,
--
Carlos


"Mike Smith" wrote:

I have a spreadsheet of historical data I am creating. Each row would be a
single project and there are several columns that have different information
about each project. I would like to create a button in the header of each
column that would give me an option to sort the rows by the custom values in
each column. For example I may want to see all union projects, or all
non-union projects, or all projects that were apartments or condos. I hope
this description makes sense.