Thanks, but the formula will only tell what the max number is, My company may
rank 3rd out of all the companies, and taht is waht I need, I will not
always be the maxium number. Hoope this makes sense

"Dave F" wrote:

=max(A1:A5) etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"cyndi" wrote:

Hello,
I am using excel 2003
I have a row of data of where each company ranks for sales, I want to be
able to see what number my company is based on ohter numbers for example

ESPN ESPN2 A&E Mundo CNN en Español CNN
168.6 238.4 256.7 108.0 626.2

Let say I work for CNN (which I do not) CNN would be rank number 1

Is there a formula for this? Instead of manually have to look at each row

Thanks so much