Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "functions"

71 prompts matching "functions"

"functions" ✕ Clear all ✕
coding Intermediate

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

#code review #pull request #software engineering
👁 13 views
data Advanced

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

#data #sql #window-functions
👁 13 views
excel Advanced

Audit a Workbook for Broken or Slow Formulas

You are an Excel auditing specialist. Walk me through a systematic audit of a wo...

#excel #audit #performance
👁 13 views
coding intermediate

JavaScript TypeScript Generic Utility Functions Library

Create a TypeScript utility functions library with these categories: 1) Array ut...

#TypeScript #utility functions #JavaScript
👁 12 views
data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#SQL #window functions #analytics
👁 12 views
data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#SQL #GROUP BY #window functions
👁 12 views
excel Intermediate

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#dynamic arrays #FILTER #SORT
👁 12 views
excel Intermediate

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

#dynamic arrays #filter #sort
👁 12 views
coding Intermediate

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

#coding #refactoring #clean-code
👁 12 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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...

#XLOOKUP #INDEX MATCH #multi-criteria lookup
👁 11 views
data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

Build a complete SQL-based customer cohort analysis system for subscription or e...

#data #sql #cohort-analysis
👁 11 views
excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas
👁 11 views
excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel formulas #dynamic arrays #dashboard
👁 11 views
excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#excel #test-data #random
👁 11 views
excel intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif
👁 10 views
excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

#excel #lambda #custom-functions
👁 10 views
coding Advanced

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 ...

#coding #typescript #generics
👁 10 views
finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#finance #cash-flow #forecasting
👁 10 views
coding Advanced

Refactor Legacy JavaScript to Modern ES2024 Standards

Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...

#javascript #refactoring #es2024
👁 10 views
data Advanced

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql
👁 9 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 9 views
data Intermediate

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#data #SQL #funnel analysis
👁 8 views
excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup
👁 8 views
coding Advanced

Refactor Tangled Function Into Smaller Pure Pieces

Act as a code reviewer focused on readability. Below is a function that has grow...

#coding #refactor #clean-code
👁 7 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval