daddioja wrote:
Another forum user helped me out with this formula. It works great for
my application, but I don't completely understand it. Particularly, I
am unsure of the use of the brackets at the beginning and end of the
formating. Can someone clear this up for me? Thanks, Jason

{=SUM(IF(B2B$2:B$21,1/COUNTIF(B$2:B$21,B$2:B$21)))+1+ROW()/10^10}


It tells excel to consider the material inside the brackets as an array
and to perform all of the fuctions on the array not an individual
value. They are quite difficult to understand and not something I make
much use of. Essentially its a way to do several calculations on a
large amount of numbers without needing to copy equations or do
multiple steps. Anything an array can do can be done without them but
sometime it takes a lot more steps.

Ghostwriter