pivot tables?
 

By combine two cells, I mean mathematically add values of two cells.

Patty wrote:
Each person in my database (of over 1000) has two rows of information. I want
to combine two cells for each person so that there's just one entry per
person. Someone suggested a pivot table but I don't know how to do that!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

Use a caculated field within the pivot table