Search: "INDEX MATCH"

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

#TypeScript #utility functions #JavaScript

coding intermediate

JavaScript TypeScript Generic Utility Functions Library

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

#newsletter #email #writing

writing intermediate

Newsletter Issue Writing Template for Niche Audience

Write a weekly newsletter issue for [newsletter name and niche]. Structure: 1) P...

#postgresql #indexing #performance

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

#XLOOKUP #INDEX MATCH #multi-criteria lookup

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

#marketing #google-ads #ppc

marketing intermediate

Google Ads Search Campaign Setup Optimization Complete Playbook

Build a comprehensive Google Ads search campaign from setup to optimization. Cov...

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

coding Advanced

ChatGPT Prompt: REST API Endpoint Naming and Versioning Convention Reviewer

You are an API design reviewer. Audit my endpoint list for naming, REST semantic...

#coding #api #rest

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

data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby

#SEO #keyword research #content strategy

marketing Intermediate

SEO Keyword Research Strategy: Content Gap Analysis Guide

Help me conduct a comprehensive SEO keyword research and content gap analysis. I...

#sql #optimization #performance

data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

#excel #formula #duplicates

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#influencer marketing #campaign brief #social media

marketing Intermediate

Influencer Marketing Campaign Brief Template

Create a comprehensive influencer marketing campaign brief for [brand] promoting...

#cro #landing page #conversion

marketing Advanced

Conversion Rate Optimization Audit Landing Page Heuristic Review

You are a CRO consultant. Audit my landing page at [URL] for [CONVERSION GOAL]. ...

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#401k #roth ira #retirement planning

finance Intermediate

ChatGPT Prompt: Roth vs Traditional 401k Contribution Decision Framework

Help me decide between Roth and Traditional 401(k) contributions based on: - Cu...

#marketing #paid search #ppc

marketing Advanced

Paid Search Campaign Brief with Negative Keyword Strategy

Act as a paid search strategist. Build a campaign brief for [BUSINESS] launching...