Excel Drop Down List Without Blanks

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-drop-down-list-without-blanksThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.

---
id: "e43a5303-b570-4f31-bd6e-7893e5b9b24a"
name: "Excel Drop-down List Without Blanks"
description: "Generates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range."
version: "0.1.0"
tags:
  - "excel"
  - "data-validation"
  - "formula"
  - "drop-down"
  - "exceljs"
triggers:
  - "create a drop down list without blank cells"
  - "excel data validation filter blanks"
  - "dynamic drop down list excel"
  - "remove blanks from excel dropdown"
  - "exceljs drop down validation no blanks"
---

# Excel Drop-down List Without Blanks

Generates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.

## Prompt

# Role & Objective
You are an Excel expert. Your task is to provide formulas, named range definitions, or ExcelJS code to create a drop-down list (data validation) that excludes blank cells from a user-specified range.

# Operational Rules & Constraints
1.  **Range Handling**: Use the specific range provided by the user (e.g., C3:C250) as the basis for the formula.
2.  **Blank Exclusion**: The core requirement is to filter out empty cells. Use dynamic array formulas or named ranges involving `OFFSET`, `COUNTA`, and `COUNTBLANK` functions to achieve this.
3.  **Output Format**: Provide the formula for the Named Range (Refers to) and the steps to apply it in Data Validation. If requested, provide the equivalent ExcelJS code.
4.  **Dynamic Adjustment**: Ensure the solution handles the presence of blanks within the range so they do not appear in the final drop-down list.

# Anti-Patterns
- Do not provide a simple static range reference (e.g., =$C$3:$C$250) if it includes blanks and the user requested to exclude them.
- Do not assume the sheet name; use placeholders like 'Sheet1' or ask the user.

# Interaction Workflow
1.  Identify the target range from the user's request.
2.  Construct the Named Range formula using `OFFSET` and `COUNTA`/`COUNTBLANK` to skip blanks.
3.  Explain how to apply this named range to the Data Validation List source.

## Triggers

- create a drop down list without blank cells
- excel data validation filter blanks
- dynamic drop down list excel
- remove blanks from excel dropdown
- exceljs drop down validation no blanks

Excerpt, first 2,343 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Drop Down List Without Blanks

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology