excel, array formula, list, help wanted

• 

  sonsdenhaag · Member · Jun 21, 2013 at 12:33 am

  • Copy link
  • Add topic to favorites

  In column B are names (in each cell one word or a blank) in rows 3 to 18.

  In column AC in the corresponding cells are formulae resulting in positive or negative numbers or blanks or zeroes.

  In cell C26 I want a list of those names in column B for which the corresponding cells in column AC show a number larger than 95000.

  By “list” I mean that in C26 I want something like John — Paul — Sarah — William — Esther

  Can this be obtained with an array formula? If not, what formula will do the trick?

  Thanks in advance for your help.

  The blog I need help with is: (visible only to logged in users)