View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tmirelle tmirelle is offline
external usenet poster
 
Posts: 26
Default Rank if between 1 & 5

Have managed to rank data,

would like it to produce the following

if rank is between 1 & 5 show the rank; if not show 0