How to use it
A practical browser-based utility for quick checks, planning and clearer work. Enter the requested values, review the result and keep the assumptions with your record.
- Enter the source values carefully.
- Select any required options and run the calculation.
- Review the result, formula and worked example before using it in a decision.
Formula
The method used by this tool is keep the first occurrence of each line. Keep the source values and units with the result so another person can reproduce the calculation.
Worked example
A, B, A → A, B. This example demonstrates the sequence; your result depends on the values and options you enter.
Excel guidance
Use this workbook approach: =TEXTJOIN(CHAR(10),TRUE,UNIQUE(TEXTSPLIT(A2,CHAR(10)))). Format percentage results as Percentage, dates as dates, and financial values with the correct currency. Avoid rounding intermediate steps.