View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bpkaufman@gmail.com is offline
external usenet poster
 
Posts: 19
Default Unique Rank function not working

Can anyone figure out why this formula would not be working (all cell
formatting is in tact):

RANK(G6,G$6:G$130)+COUNTIF(G$6:G6, G6)-1

Thanks in advance,

BK