Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I posted this question earlier, but perhaps I didn't describe it properly. I
have 3 columns of data. Width, Height & Quantity (example: 45 30 13). I also have about 500 rows of records that consist of about 50 different size combinations. I need a total number of pieces for each size. I can go through the 500 rows and list all the sizes, then do a calculation to give me the total. However, it takes a very long time to go through the 500 rows. Can Excel somehow search and find all the size combinations and list them at the beginning or end of the table with the total of each size? Or do I need to do this in Access or Filemaker? Thanks to all who previously tried to help me with this problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
What type of /program/database is Excel? | Excel Discussion (Misc queries) |