Search: "filter function"

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#typescript #generics #utility-types

coding advanced

TypeScript Generics and Utility Types Complete Practical Guide

Create a comprehensive practical guide to TypeScript generics and built-in utili...

#coding #testing #unit-tests

coding intermediate

Unit Test Generator for Existing Code

Generate comprehensive unit tests for my existing code. Details: Code to test: ...

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#job-description #recruiting #hiring

hr Intermediate

Write a Job Description That Filters In, Not Out

Rewrite this job description to filter the right people IN rather than the wrong...

#react #performance #virtualization

coding advanced

React Performance Optimization Techniques for Large Lists

Optimize a React application that renders a large list of [data type, e.g., 10,0...

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

productivity Intermediate

Inbox Zero Triage Protocol for a 2000-Email Backlog

I have 2000+ unread emails in my inbox. Build me a one-time triage protocol I ca...

#productivity #inbox-zero #email

#unit testing #edge cases #testing

coding Intermediate

Write Unit Tests for Function with Edge Case Coverage

Write a comprehensive unit test suite for this function: [PASTE FUNCTION] Use ...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#code review #pull request #quality assurance

coding Intermediate

Code Review Checklist for Pull Request Quality Assurance

Create a comprehensive code review checklist for [programming language/framework...

#coding #typescript #generics

ChatGPT Prompt: TypeScript Type Inference Helper for Complex Generic Functions

You are a TypeScript type-system expert. Help me get correct types on a generic ...

#hr #onboarding #new-hire

hr Intermediate

ChatGPT Prompt: Onboarding Plan for a New Hire's First 30-60-90 Days

You are a people operations lead. Build a 30-60-90 day onboarding plan for a new...

#excel #dynamic-arrays #textsplit

excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#coding #testing #property-based

Generate Property-Based Tests from Spec

Given the function signature and natural-language specification below, generate ...

#finance #forecasting #fpa

finance Advanced

Build a forecast that explains its variance to itself every month

Act as an FP&A lead. Build a monthly revenue forecast for [BUSINESS] that does w...

#coding #refactor #clean-code

ChatGPT Prompt: Code Refactor Plan for a Long, Tangled Function

You are a senior engineer guiding a safe refactor. Help me decompose a long, tan...

#coding #refactoring #legacy code

Refactor Legacy Function with Tests

Act as a senior engineer. I will paste a legacy function in [LANGUAGE]. Step 1: ...

#excel #reconciliation #fuzzy match

excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#business #leadership #delegation

business Advanced

Business: Replace Myself in a Role I'm Both Good At and Bottlenecking

I'm still doing [ROLE/FUNCTION] in my company because I'm the best at it — and i...

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

#coding #testing #unit-tests

coding Intermediate

Write a test that captures intent, not implementation

You are a test design coach. Here is a function: [PASTE_FUNCTION]. The existing ...