Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default # rank formula

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rank with an array formula Tim Excel Worksheet Functions 2 September 1st 06 02:42 PM
RANK, duplicate ranking but no gaps in rank arron laing Excel Worksheet Functions 4 June 14th 06 07:57 AM
RANK formula KG Excel Discussion (Misc queries) 3 September 23rd 05 03:27 PM
Rank items, select one start date, have remaining dates follow based on rank rob normerica Excel Discussion (Misc queries) 1 August 15th 05 09:36 PM
Rank Formula lightninbug Excel Worksheet Functions 3 January 21st 05 10:59 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"