Search: "functions"

#excel #SUMIFS #multiple criteria

SUMIFS with Multiple Criteria

Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...

👁 37 views

excel beginner

Excel SUMIF, COUNTIF & AVERAGEIF Conditional Aggregation Mastery

I need to master Excel conditional aggregation formulas. Please provide: 1. A c...

#sumif #countif #averageif

👁 36 views

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#coding #sql #window-functions

👁 35 views

data Advanced

SQL for Business Intelligence

Write SQL queries for a business intelligence dashboard. Tables: orders, custome...

#data #SQL #business intelligence

👁 33 views

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#lambda #custom-functions #excel

👁 32 views

INDEX MATCH as VLOOKUP Alternative

Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...

#excel #INDEX #MATCH

👁 31 views

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

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

👁 30 views

Text Manipulation Formulas

Show me essential Excel text formulas with examples: 1) Extract first name from ...

#excel #text #LEFT

👁 28 views

excel Beginner

Dynamic Date Formulas

Give me the most useful Excel date formulas for business: 1) Calculate age from ...

#excel #date #DATEDIF

👁 27 views

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

👁 27 views

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#dynamic array #FILTER #SORT

👁 25 views

excel advanced

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...

#excel #array-formulas #sequence

👁 25 views

coding intermediate

JavaScript Async/Await: Error Handling Patterns and Best Practices

Explain and demonstrate best practices for async/await error handling in JavaScr...

#JavaScript #async await #error handling

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#excel #audit #performance

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 Beginner

VLOOKUP for Matching Data Between Sheets

Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...

#excel #VLOOKUP #formula

#excel #pivot-table #reporting

excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#excel #index match #formula

excel Advanced

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#coding #refactoring #clean-code

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