Rank non Contiguous

[BNT1 via OfficeKB.com]

Hi

Is there any way to have non contiguous range in Rank

Currently using =RANK(D6,$D$6:$D$110)+(COUNTIF($D$66,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$66,D6)-1), but did
not work

Help appriciated

Brian

 

[Peter T]

Maybe if you deduct this from the total
SUMPRODUCT(--(D9394>D6))

I haven't tied that in with your Countif part, so better check that aspect

Regards,
Peter T

 

[Barb Reinhardt]

I haven't tried it, but I think I'd try to create a non-contiguous named
range and put that in your formula.

 

[BNT1 via OfficeKB.com]

thank you both for your response
I did try the comma to separate the ranges, but could not get it to work.
The non contiguous named range worked a treat

regards

I haven't tried it, but I think I'd try to create a non-contiguous named
range and put that in your formula.

Hi

[quoted text clipped - 10 lines]

Brian