GPT-5.5 Excel 指南（2026）：公式与数据分析工作流

Excel 365. Help me with formulas only.

Sheet: Orders
Columns:
A OrderID (text)
B OrderDate (date)
C Region (text)
D Revenue (number)
E Status (text: Open, Closed)

Sample rows:
ORD-1 | 2026-05-01 | West | 1200 | Open
ORD-2 | 2026-06-15 | East | 800 | Closed

Goal: [your one sentence]
Return: one formula for F2 to fill down, and explain each part in plain English.

Use XLOOKUP to pull Price from Sheet2!A:B into Orders!F2.
Sheet2: A=SKU, B=Price. Return 0 if missing.

=IFERROR(XLOOKUP(B2, Sheet2!$A:$A, Sheet2!$B:$B, 0), 0)

=FILTER(A2:E100, (E2:E100="Open")*(TODAY()-B2:E100>30))

=SUMIFS(D:D, C:C, "West", B:B, ">="&DATE(2026,4,1), B:B, "<="&DATE(2026,6,30))

=UNIQUE(FILTER(C2:C100, D2:D100>0))

Formula returns #SPILL!. Here is my formula: [paste]
Here is the occupied range in column G: G2:G50 has data.
Fix with minimal change.

I need a simple dashboard for sales leadership.
Metrics: MTD revenue, QoQ growth %, top 5 regions, % open orders > 30 days.
Data: Orders sheet schema above.
Output:
1) metric definitions in Excel terms
2) suggested chart types
3) one pivot table layout (rows, columns, values)
4) risks if Status values are inconsistent

import os
from openai import OpenAI

client = OpenAI(api_key=os.environ["OPENAI_API_KEY"])

prompt = """
Given columns OrderID, OrderDate, Region, Revenue, Status (Open/Closed),
return Excel 365 formula for column Flag where Flag="Stale" when
Status=Open and OrderDate is more than 30 days before TODAY().
Return JSON: {"formula": "...", "explanation": "..."}
"""

resp = client.chat.completions.create(
    model="gpt-5.5",
    messages=[{"role": "user", "content": prompt}],
    response_format={"type": "json_object"},
)

print(resp.choices[0].message.content)

Excel 365. Sum Revenue where Region=H2 and OrderDate in current calendar month.
Headers in row 1, data rows 2:500. Return formula for I2.

Return formula pipeline: UNIQUE list of OrderID where Status=Open,
then count duplicates per ID in helper column. Prefer dynamic arrays.

Write two sentences explaining why open orders >30 days rose,
given these aggregate numbers: [paste only aggregates, no row-level PII].

Excel 365 with Table name "OrdersTable" on Sheet1.
Columns: OrderID, OrderDate, Region, Revenue, Status.
Goal: calculated column "StaleFlag" = TRUE when Status is Open and OrderDate < TODAY()-30.
Use structured references like OrdersTable[Status].

=IF((OrdersTable[Status]="Open")*(OrdersTable[OrderDate]<TODAY()-30), TRUE, FALSE)

Source is CSV with mixed date formats in column C.
Steps needed: promote headers, parse dates, trim Region text, remove duplicate OrderID keeping latest date.
List each step as Power Query UI action names.

Office Script for Excel 365: on Sheet1, hide rows where column E = "Closed"
and column B is older than 90 days. Return count of hidden rows.

Google Sheets, not Excel. Use FILTER, QUERY, or MAP/LAMBDA where appropriate.
No XLOOKUP.

=QUERY(A1:E, "select C, sum(D) where E = 'Open' group by C label sum(D) 'Revenue'", 1)