Real ChatGPT answer · index seedW14Hb1MGNkocompleteFinance and banking · cryptocurrencyinformational

What are the best XLOOKUP and dynamic array formulas in Excel to reconcile my decentralized wallet transaction history with my cost basis for tax season?

ChatGPTgpt-62 queries10/31/2026
Download run

Fan-out diagram

The searches the AI actually ran for this prompt.

SEED QUERY
What are the best XLOOKUP and dynamic array formulas in Excel to reconcile my decentralized wallet transaction history with my cost basis for tax season?
2 real searches · 1 real-search pass
Microsoft Excel XLOOKUP FILTER LET UNIQUE SORT dynamic array function documentationGoogle ↗
OBSERVED
IRS digital assets cost basis wallet-by-wallet records broker reporting 2025 2026 FAQGoogle ↗
OBSERVED

Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.

Query classes

Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.

Classifying 2 queries…

Searches and sources

ChatGPT2 real searches · gpt-6
Microsoft Excel XLOOKUP FILTER LET UNIQUE SORT dynamic array function documentation Google ↗
IRS digital assets cost basis wallet-by-wallet records broker reporting 2025 2026 FAQ Google ↗

Queries

2 queries · click a column to sort
Query / typeSearchIntentQuery classRouting formatClusterFreq ↓Weight
Microsoft Excel XLOOKUP FILTER LET UNIQUE SORT dynamic array function documentation
OBSERVED
Google ↗
AI Mode ↗
————1x
of 1
IRS digital assets cost basis wallet-by-wallet records broker reporting 2025 2026 FAQ
OBSERVED
Google ↗
AI Mode ↗
————1x
of 1