C
crispino
Hi all,
I am trying to keep track of various types of tomato seedlings on growing
trays. Each tray is divided into eight sections and each section will have a
certain number of seedlings in it. However the data are not contiguous, but
instead are laid out in such a way so as to approximate everything's position
in the tray. The data are always arranged with the number above and the type
in the row below. A typical example might look something like this:
4 3
Big Boy Early Girl
4 4
Roma Big Boy
2 3
Early Girl Beefsteak
4 4
Big Boy Roma
My questions is, is there a way to do a dynamic sum of each type? So, in
the example above, there would ultimately be a list that looks like:
3 Beefsteak
12 Big Boy
5 Early Girl
8 Roma
The fact that the data types are not separated into discrete columns and
rows have hampered my efforts to figure this out so far. How would I do this?
Any help would be greatly appreciated. I'm using Excel 2003.
- Chris
I am trying to keep track of various types of tomato seedlings on growing
trays. Each tray is divided into eight sections and each section will have a
certain number of seedlings in it. However the data are not contiguous, but
instead are laid out in such a way so as to approximate everything's position
in the tray. The data are always arranged with the number above and the type
in the row below. A typical example might look something like this:
4 3
Big Boy Early Girl
4 4
Roma Big Boy
2 3
Early Girl Beefsteak
4 4
Big Boy Roma
My questions is, is there a way to do a dynamic sum of each type? So, in
the example above, there would ultimately be a list that looks like:
3 Beefsteak
12 Big Boy
5 Early Girl
8 Roma
The fact that the data types are not separated into discrete columns and
rows have hampered my efforts to figure this out so far. How would I do this?
Any help would be greatly appreciated. I'm using Excel 2003.
- Chris