JesterX1313
New Member
- Joined
- Dec 12, 2003
- Messages
- 10
Ok, I have an interesting one. If anyone could help, that would be great. I'll try to describe this as best as possible. I have 2 rows. Looks like this...
A B
1 apple
1 air
1 balloon
2 apple
2 core
3 apple
3 balloon
3 bags
3 chips
What I'm looking for is something that will allow me to count the number of times a number has a letter (first letter of column b). So 1, 2, and 3 have the letter a so I'd want the count to show 3 for a, 2 for b, 2 for c. I can't figure out how to make it count without counting the mulitple times a shows up in one. Also (if it's possible, and if not, no big deal) count this even if the numbers are not in any order. Please let me know if this made any sense. Thanks for any help.a
A B
1 apple
1 air
1 balloon
2 apple
2 core
3 apple
3 balloon
3 bags
3 chips
What I'm looking for is something that will allow me to count the number of times a number has a letter (first letter of column b). So 1, 2, and 3 have the letter a so I'd want the count to show 3 for a, 2 for b, 2 for c. I can't figure out how to make it count without counting the mulitple times a shows up in one. Also (if it's possible, and if not, no big deal) count this even if the numbers are not in any order. Please let me know if this made any sense. Thanks for any help.a