Thread: Rank non Contiguous
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
  
Posts: 125
Default 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

Reply With QuoteReply With Quote