How-to
How to List Unique Values in Excel With the UNIQUE Function
Use Excel's UNIQUE function to pull a deduplicated list from a range, sort it, and avoid the closed-workbook trap.
· 3 min
Tech, figured out.
Clear how-to guides, plain explanations and sourced news on the software, devices and cars you use.
Just in
SignDrop Windows Zero-Day Grants SYSTEM Access, and No Patch Exists YetOutlook Outage on 12 November: What Is ConfirmedGemini 4 Hydrogen Replaces 3.8 Flash: Who Gets It and What It CostsApache 2.4.71 Fixes Critical HTTP/2 RCE: How to Check If You're ExposedNintendo Ends Google and Apple Sign-In on Jan 26, 2027: What ChangesGoogle Fi Brings Back Network Switching With a 'Secondary' PartnerNotion AI Chats Exposed in Fireworks AI Breach: Check Your WorkspaceAndroid Auto Now Requires Android 11: Is Your Phone Cut Off?Outlook.com Reportedly Bouncing Email From Domains Without DMARC
Pick up where you left off
How-to guides
Do the thing, step by step.
82 articles →
Explainers
Finally understand how it works.
57 articles →
Buying guides
What to buy, and what to skip.
51 articles →
News
What changed, with the sources.
67 articles →
Guides worth keeping
Useful today, still useful next year.
Buying guide
How to Choose a Qi2 Charger: Check the Database, Not the Box
· 4 min
How-to
How to Join Cells in Excel With TEXTJOIN (and Skip the Blanks)
· 4 min
Buying guide
How to Choose a Portable Power Station: Start With Your Own Devices
· 4 min
Explainer
Clear Cache vs Clear Storage on Android: What Each One Deletes
· 7 min
Explainer
Does Shut Down Really Shut Down Windows 11? Where to Check Before You Trust It
· 2 min
How-to
How to Split Text in Excel With TEXTSPLIT (Names, Lists, Delimiters)
· 4 min
How-to
How to Use IFERROR in Excel to Replace Errors With Your Own Value
· 3 min
Buying guide
How to Choose an M.2 SSD for PS5: Check Heatsink Height Before Speed
· 6 min
How-to
How to Use VLOOKUP in Excel: Syntax, Examples and Error Fixes
· 3 min
How-to
How to Convert Text to Numbers in Excel (Green Triangle, VALUE, and Paste-Back)
· 3 min
What just happened
All news →
Pick a topic
All topics →
Fresh on AnIntent
How-toHow to Use FILTER in Excel With Two Conditions and a No-Match Message
Learn Excel's FILTER syntax, how to filter on two conditions at once, sort the result, and show your own text when nothing matches.
How-toCloud & Productivity Software
How to Fit an Excel Sheet on One Page When Printing (and Keep It Readable)
Print a wide Excel sheet on one page or one page wide with Scale to Fit, read the Scale box for legibility, and fix Fit to when it seems broken.
How-toCloud & Productivity Software
How to Create an Excel PivotTable (and Fix Fields That Count, Not Sum)
Build an Excel PivotTable with Insert > PivotTable, place it where you want, and fix a field that shows a COUNT instead of a SUM.
ExplainerYour Drive Shows Less Storage Than Advertised? Start With Apple's Explanation
If a drive, phone or Mac shows less storage than the box says, these are the Apple pages to read before you assume anything is wrong.
How-toHow to Use SUMIFS in Excel to Add Values That Meet Several Conditions
Write an Excel SUMIFS formula that adds numbers only when several conditions match, with wildcards and "not equal" criteria.
How-toHow to Use COUNTIF in Google Sheets to Count Cells That Match
Count cells that match one condition in Google Sheets with COUNTIF, including greater-than tests, text matches and * and ? wildcards.
ExplainerSmartphones
Moving an eSIM From Android to iPhone: When You May Need Your Carrier
What Apple's support page says about moving an eSIM from an Android phone to an iPhone, and when your carrier may have to step in.
How-toHow to Create a Drop-Down List in Excel With Data Validation
Add a drop-down list to an Excel cell with Data Validation, keep the header out of the choices, and fix a greyed-out Data Validation button.
How-toHow to Use XLOOKUP in Excel to Find a Value in Another Column
Write a basic Excel XLOOKUP formula and check whether your Excel version supports the function.
How-toCloud & Productivity Software
How to Use Flash Fill in Excel (Ctrl+E) to Split or Join Names
Use Excel's Flash Fill (Ctrl+E) to split or combine names, turn it on if it won't preview, and switch to formulas when your data changes.
Buying guideHow to Choose Matter Smart-Home Devices Without Guessing
What to check before buying Matter smart-home devices: your ecosystem, the connection type, and what the CSA's Matter 1.4 announcement covers.
ExplainerHome Networking
Should 2.4 GHz and 5 GHz Wi-Fi Share One Name? What Apple Says
Apple recommends one Wi-Fi name for every band. Here is why, and what 2.4, 5 and 6 GHz each trade between range and speed.
We show our work, so you can check it.
1
Researched live
Written with AI from pages read on the web that day, not from memory.
2
Every claim linked
Sources sit next to the facts they support, one click away.
3
Checked before publishing
Links and claims are tested automatically. Failures do not go live.