Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here is my data
ColA-ColB-ColC ABC-1- ABC-4- ABC-2- DEF-4- DEF-5- DEF-10- FGH-19- FGH-12- FGH-1- FGH-4- FGH-8- Is there any formula I can use in Column C where it will input a 1 if the number in Column B is ranked in the top two of Column A, and a 0 if it's not? So final result would look like: ColA-ColB-ColC ABC-1-0 ABC-4-1 ABC-2-1 DEF-4-0 DEF-5-1 DEF-10-1 FGH-19-1 FGH-12-1 FGH-1-0 FGH-4-0 FGH-8-0 FGH-9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |