filter_and_count
Count rows matching conditions with 14 operators.
How to use it
filter_and_count is exposed by the MCP Excel MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the filter_and_count tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Excel
pip install -e .Other tools in MCP Excel (24)
Perform aggregation with optional filters (8 operations).
Venn diagram analysis - intersections, unions, exclusive zones.
Arithmetic expressions between columns.
Smoothing with specified window size.
Period-over-period growth analysis.
Cumulative sum with optional grouping.
Diff between two sheets using key column.
Correlation matrix between 2+ columns.
Anomaly detection using IQR or Z-score.
Classify data into multiple categories in one call (6x faster).
Retrieve filtered rows with pagination.
Locate column across multiple sheets.
Detect duplicate rows by specified columns.
Find null/empty values with detailed statistics.
Quick column enumeration without loading full data.
Statistical summary - count, mean, median, std, quartiles.
Comprehensive column profiling - types, stats, nulls, top values.
Detailed sheet analysis with auto-header detection.
Extract unique values from a column.
Frequency analysis - top N most common values.
Pivot table with multi-column grouping.
Get file structure overview - sheets, dimensions, format.
Rank by column value with top-N filtering.
Search value across all sheets.