Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "FILTER function"

134 prompts matching "FILTER function"

"FILTER function" ✕ Clear all ✕
coding Intermediate

Write the test cases I'd forget for this function

I'll paste a function and describe what it's supposed to do. List the test cases...

#coding #testing #edge cases
👁 3 views
excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#excel #dropdown #data validation
👁 3 views
coding Advanced

Review my function for the bug I can't see

Here's a function that passes my obvious tests but feels fragile. Act as a caref...

#coding #code review #edge cases
👁 3 views
coding Advanced

Refactor a Long Function into Clean, Testable Pieces

You are a software craftsperson focused on readable, maintainable code. I will p...

#coding #refactoring #clean code
👁 3 views
excel Advanced

Write a Reusable LAMBDA Function

You are an expert Excel 365 power user. Help me turn a repetitive calculation in...

#excel #lambda #automation
👁 3 views
excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

#excel #formulas #xlookup
👁 3 views
coding Intermediate

Debug My Code With a Root-Cause Walkthrough

You are a senior software engineer doing a calm, systematic debugging session. I...

#coding #debugging #troubleshooting
👁 3 views
creative Beginner

Generate 20 Fresh Ideas Without the Obvious Ones

You are a creative director running a fast ideation sprint. I will give you a ch...

#creative #brainstorming #ideation
👁 3 views
data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#SQL #window functions #query optimization
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#excel #formulas #automation
👁 2 views
coding intermediate

Write Unit Tests for My Function

Act as a senior software engineer. Write comprehensive unit tests for this funct...

#coding #testing #unit tests
👁 2 views
coding Intermediate

Generate Unit Tests for a Function

Act as a test engineer. Write unit tests for this function: [PASTE FUNCTION] usi...

#coding #testing #unit-tests
👁 2 views
excel Intermediate

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

#excel #formulas #dynamic-arrays
👁 2 views
coding Intermediate

Write Unit Tests for a Function

You are a test engineer. I will paste a function and you will write a thorough s...

#coding #testing #unit-tests
👁 2 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval