Back to Prompts
Excel
Excel Copilot: Complex Array Formulas
PromptCraft April 24, 2026
275 copies 31 likes
Create dynamic array formulas using FILTER, SORT, UNIQUE, and SEQUENCE for advanced data manipulation.
Prompt
# Excel Copilot: Complex Array Formulas Create dynamic array formulas using FILTER, SORT, UNIQUE, and SEQUENCE for advanced data manipulation. This prompt helps you leverage GitHub Copilot and Microsoft Copilot for excel tasks. Use this prompt template to get consistent, high-quality results. ## How to Use 1. Copy the prompt template below 2. Customize the bracketed sections for your specific use case 3. Paste into Copilot Chat or M365 Copilot 4. Iterate on the output as needed ## Prompt Template Create dynamic array formulas using FILTER, SORT, UNIQUE, and SEQUENCE for advanced data manipulation.
Comments
More Prompts
View allDevelopment
GitHub Copilot Code Review Companion
Structured code review using GitHub Copilot. Security audit, performance analysis, test coverage assessment, and PR review checklists for production codebases.
C
CommunityProductivity
Microsoft 365 Copilot Meeting Workflow
End-to-end meeting productivity with M365 Copilot. Covers pre-meeting prep, real-time notes, action item extraction, and automated follow-ups across Teams and Outlook.
C
CommunityCode Generation
Build State Machine Implementation
Create a type-safe state machine with transitions, guards, actions, and visualization support using XState patterns.
P
PromptWizard 112 190
Coding
Security Code Audit
Comprehensive security audit checking for OWASP Top 10 vulnerabilities with proof-of-concept examples, fixes, and a hardened code version.
C
CommunityCoding
Bug Triage and Root Cause Analysis
Systematic bug triage with root cause analysis, ranked hypotheses, step-by-step debugging instructions, and preventive solutions.
C
CommunityProductivity
Travel Planning Assistant
Generate a complete trip plan with day-by-day itinerary, budget breakdown, restaurant picks, and practical tips using real-time travel data.
C
Community