Search: "index match"

#coding #JavaScript #form validation

INDEX MATCH as VLOOKUP Alternative

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

#excel #INDEX #MATCH

👁 11 views

coding Beginner

JavaScript Form Validation

Write JavaScript form validation for a registration form with: email (valid form...

👁 11 views

#database design #schema #SQL

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

👁 10 views

design intermediate

Wireframe Feedback and Usability Evaluation

Evaluate the following wireframe/prototype for [product type] targeting [user ty...

#design #wireframe #usability

👁 10 views

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

👁 9 views

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#excel #xlookup #index match

👁 8 views

legal Advanced

ChatGPT Prompt for Privacy Policy Gap Check on a SaaS Signup Flow

Act as a privacy risk spotter. Review my SaaS signup and onboarding flow against...

#privacy policy #saas compliance #data collection

👁 8 views

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

#hr #compensation #salary-bands

hr advanced

Compensation Benchmarking and Salary Bands

Help me design a compensation benchmarking framework and salary band structure f...

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

#marketing #google ads #ppc

marketing Advanced

Google Ads Campaign Structure for E-commerce

Build a complete Google Ads campaign structure for an e-commerce store selling [...

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

#sql migration prompt #rollback safe deployment #database schema change

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

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

data advanced

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql

#coding #sql #query optimization

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

productivity intermediate

Team Task Delegation Framework

Help me create a delegation framework for assigning tasks to my team of [team si...

#productivity #delegation #team-management

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

data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

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

#pandas #python #groupby