Generate A List Based On Criteria

2 minute read

Generate a list of items based on a criteria that doesn’t show any blanks or spaces.
20 Fruits and Vegetables listed below, choose either a fruit or vegetable and a list will populate without blanks or spaces.

Formula for E2: remember to use Ctrl + Shift + Enter as this is an array formula

{=IF(COUNTIF(A:A,$D$2)

Leave a Comment