| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hlp! Named range Advanced Filter Criterion | Excel Discussion (Misc queries) | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| Select value from a range given a rank | Excel Discussion (Misc queries) | |||
| Sum a range based on a criterion | Excel Worksheet Functions | |||
| Multiple criterion including wildcards to sum in a range | Excel Worksheet Functions | |||
Threaded Mode
