yes, thanks that is what I was looking for.

Dave for your response, I understand you are not mind readers, i wasn't
asking for help on the rank functions, becasue I was already confusing you as
it was.

I am all set, thanks again, and I will post this as helpful

"Gary''s Student" wrote:

I understand now. Let's say your company is in column E and its number is in
E2. Its rank will be:

=RANK(E2,2:2,0)

A value of 1 means its in first place, etc.
--
Gary''s Student - gsnu200713