Search: "functions"

#dynamic arrays #filter #sort

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

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

👁 22 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

👁 21 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

👁 21 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

👁 21 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

#dynamic arrays #FILTER #SORT

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

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

#excel #lambda #custom-functions

excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

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

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

#code review #pull request #software engineering

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

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#javascript #refactoring #es2024

coding Advanced

Refactor Legacy JavaScript to Modern ES2024 Standards

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

#data #sql #cohort-analysis

data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

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

👁 19 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

👁 19 views

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

#SQL #GROUP BY #window functions

data intermediate

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

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

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

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

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

#finance #cash-flow #forecasting

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

👁 17 views

#excel #formulas #xlookup

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

👁 17 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

👁 16 views