Forum Discussion
Solved
Excel: Condensing and Counting
On the left is a table documenting individual plants of a single species (B) in different plots. There is also a Type designation for each plot. I would like to create a new table which lists each plot just once along with the number of plants found in each plot and the Type designation for the plot. Suggestions?
| PLOT | SPECIES | TYPE | MASTERID | NO. B | VEG88 | |
| 8 | B | 3 | 8 | 2 | 3 | |
| 8 | B | 3 | 10 | 2 | 2 | |
| 10 | B | 2 | 11 | 3 | 4 | |
| 10 | B | 2 | 13 | 5 | 3 | |
| 11 | B | 4 | 14 | 3 | 2 | |
| 11 | B | 4 | 15 | 1 | 1 | |
| 11 | B | 4 | ||||
| 13 | B | 3 | ||||
| 13 | B | 3 | ||||
| 13 | B | 3 | ||||
| 13 | B | 3 | ||||
| 13 | B | 3 | ||||
| 14 | B | 2 | ||||
| 14 | B | 2 | ||||
| 14 | B | 2 | ||||
| 15 | B | 1 |
4 Replies
PivotTable will work, especially if TYPE are numbers.
