Here's my example:
ColumnA Column B
1 9FT
1 9FT
1 9FT
1 9FT
2 7FT
2 7FT
2 7FT
2 10FT
3 10FT
I need a statement to count 1 = 4, 2 = 4, 3 = 1. Something without having to sum then divide by count.
Hope that makes sense? Seems simple to me but I've been stuck for several minutes now.
Thanks in advance!!
Bookmarks