As you can see by the example below, column G indicates different amounts of postage which are pulled from a lookup table. (This column actually extends ad infinitum... it has been cropped for brevity here.) There are 25 different postage amounts listed in the lookup table.
Column J needs to show the different amounts found in column G while column I needs to show how many occurences of each of those amount are found in column G.
I could list all 25 possible amounts in column J, but it would be nicer if column J simply showed the amounts that come up in column G. And wow, it'd be even better (tho not completely necessary) that those amounts in column J were sorted from smallest to largest.
I tried to wrap my little brain around this one and didn't have any luck. If someone could impart upon me the two formulas necessary to make columns I and J work, it'd be mucho appreciated!
Thanks!
bobmc
Column J needs to show the different amounts found in column G while column I needs to show how many occurences of each of those amount are found in column G.
I could list all 25 possible amounts in column J, but it would be nicer if column J simply showed the amounts that come up in column G. And wow, it'd be even better (tho not completely necessary) that those amounts in column J were sorted from smallest to largest.
I tried to wrap my little brain around this one and didn't have any luck. If someone could impart upon me the two formulas necessary to make columns I and J work, it'd be mucho appreciated!
Thanks!
bobmc