Write an Excel formula that returns the latest non-empty value in column B for each ID in column A.
tool - AI for Excel formulas
AI for Excel formulas prompt builder
Help analysts, operators, and founders turn plain English requests into formulas, explanations, and debug steps. This page is built for analysts, operations teams, founders, assistants who need to write, explain, and fix formulas faster.
Prompt builder
Fill the fields and generate a reusable prompt for this workflow.
Reusable prompts
Open prompt packExplain this formula in plain English and tell me where it might fail.
Rewrite the formula so it is easier for a teammate to maintain.