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)