Search: "FILTER function"

#business #product #prioritization

business Intermediate

Should-We-Build-This Filter Before You Spec a Feature

Before I spec out [feature name and 2-sentence description], run me through a qu...

#data #sql #query-optimization

data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#business #hiring #decision-making

business Intermediate

Business: Decide Whether to Hire, Contract, or Outsource a New Function

I need a new function in the company (e.g., design, finance, ops) and I'm torn b...

#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 #code review #maintainability

coding Intermediate

Review code like you actually have to maintain it next year

Review the code below as if you'll be the one maintaining it in twelve months. D...

data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

#LET function #nested IF #refactor

excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#email #internal-comms #leadership

email Advanced

Announce a leadership departure without rumor-mill spillover

You are an internal communications lead. Draft a company-wide email announcing t...

#productivity #calendar #meetings

productivity Advanced

Audit a calendar that's 70% meetings to find what to cut without political fallout

Act as an executive chief of staff. Audit my calendar for the last 4 weeks — [PA...

#writing #editing #revision

writing intermediate

Cut a draft by 40 percent without losing the argument or the voice

Act as a developmental editor who has cut a lot of long, well-meaning drafts. I ...

#code-comprehension #review #refactor

coding Beginner

Explain what a function does without me reading every line

Act as a senior engineer pairing with me. I will paste a function. Tell me in pl...

#coding #unit testing #tdd

coding Intermediate

Generate Unit Tests with Edge Cases for a Function

Act as a test engineer who is obsessed with edge cases. I will give you a functi...

#coding #documentation #docstrings

coding Beginner

Generate Clear Docstrings and Comments

You are an expert developer who writes great documentation. Help me add clear do...

#coding #refactoring #clean-code

coding Intermediate

Refactor This Function Without Changing Behavior

Act as a senior engineer who refactors safely. I'll paste a function and you'll ...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#strategy #offsite #decisions

business Intermediate

Business: Diagnose Why a 'Strategy Offsite' Didn't Produce Decisions

We did a 2-day strategy offsite and left without any decisions made — just slide...

#excel #data cleaning #dates

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#creative #brainstorming #ideation

creative Beginner

Brainstorm without falling into the first idea that feels okay

I keep settling on the first decent idea I have instead of pushing through to th...

excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro

#dates #data cleaning #DATEVALUE

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates

#coding #code review #explanation

coding Beginner

Explain what this unfamiliar code actually does, line by line

I'll paste a function or script in a language I half-know. Explain it in plain E...