Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rank non Contiguous
Hi
Is there any way to have non contiguous range in Rank Currently using =RANK(D6,$D$6:$D$110)+(COUNTIF($D$6:D6,D6)-1) and works well, but do need to remove D93 and D94 from the range. Tried removing the formula from the cells, however, got error, when using vlookup also tried =RANK(D6,$D$6:$D$92,$D$95:$D$110)+(COUNTIF($D$6:D6 ,D6)-1), but did not work Help appriciated Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201002/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |