Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to rank duplicate values sequentially over several ide..

 
   Mac (Home) -> Mac Excel RSS
Next:  Can Exel cross reference  
Author Message
Lukeyb

External


Since: Aug 24, 2008
Posts: 1



(Msg. 1) Posted: Sun Aug 24, 2008 1:54 pm
Post subject: How to rank duplicate values sequentially over several identical s
Archived from groups: microsoft>public>mac>office>excel (more info?)

I found the following article:
http://support.microsoft.com/kb/213916

However i have a query. I have several identical sheets, each with an
identical layout but different data. I would like to rank all the data from
one column across all the sheets. Is there any way i can do this without
amalgamating the data onto one sheet? Is the formula in the link ammendable?

Thanks
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Mean of Values EXCLUDING two lowest values - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel Gradebook help question. I need to calculate the mean of several scores after dropping the two lowest scores. I found the MIN function, but cannot determine how to omit the TWO..

How to fill in values - How to fill in values from precedings information up to the newest record. Thanks,

bar graph of custom x-values - hi all, i want to use my own values for the x-axis in a bar graph. however, it only lets me use the cell numbers, and takes the values in column a, and makes them into another series along with the values in columns b, c, and d. in other words, i'd..

Min Function that ignores values of Zero - How do I write a function that will find the lowest value greater than zero in a range of cells? This data set will never have negative numbers. Thanks, Edward Volchok

Visual Basic Howto: Scattering values on a sheet - I have been strugling with the following problem and am looking for help. On one sheet, I have 3 columns: row column Value (a text string, the result of a calculation and concatenation) I would like to move the text string into the..
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact