froggiebeckie
Board Regular
- Joined
- Sep 27, 2002
- Messages
- 87
Hi, all.
I've got records in a spreadsheet that include multiple entries for the same product.
For example: (5 records, 3 columns of data each)
Type 1, 120, 1/1/06
Type 2, 100, 1/9/06
Type 1, 50, 1/9/06
Type 3, 75, 1/8/06
Type 2, 100, 1/7/06
I'd like to be able to use SUMIF to calculate some averages, but first I need to list the different types of product listed in column 1. There are hundreds of records and may be as many as 150 different "Types", all mixed in together.
Is there a simple way (formula) to make a list of the different entries in column 1?
What about using a pivot table?
Thanks so much,
BeckieO
I've got records in a spreadsheet that include multiple entries for the same product.
For example: (5 records, 3 columns of data each)
Type 1, 120, 1/1/06
Type 2, 100, 1/9/06
Type 1, 50, 1/9/06
Type 3, 75, 1/8/06
Type 2, 100, 1/7/06
I'd like to be able to use SUMIF to calculate some averages, but first I need to list the different types of product listed in column 1. There are hundreds of records and may be as many as 150 different "Types", all mixed in together.
Is there a simple way (formula) to make a list of the different entries in column 1?
What about using a pivot table?
Thanks so much,
BeckieO