View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Taylor
 
Posts: n/a
Default Relating text to a value

Peo,

D = 7.5 and D/E = 15. I think you got it backwards. But I like your
formula. Pretty slick: a sumproduct, countif, and two arrays. You are
my hero.