View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark mark is offline
external usenet poster
 
Posts: 33
Default Rank for range with two criterion - hard

Hi,

I'd like show my problem with rank by two criterion in
table below:

Name Feature Data Rank_of_Name_and_Feature
A 1 2.5 3
A 1 3.5 2
A 0 6.3 2
A 1 6.5 1
A 0 6.8 1
A 1 1.2 4
etc...

How create rank (diminishing count Data) for the same Name
(col1) and Feature (col2)?

My data can't be sorted!!
Any help in VBA or function (excel 2k) will be appreciated

Regards
Mark