Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Standardising outputs to deal with missing/duplicate data
Matthew has attended:
Excel VBA Intro Intermediate course
If I always have to output data with a complete list of e.g. UK postcodes but my input data may have missing or duplicate entries how can I ensure that I always output a list with an entry (blank or with data) for each postcode and that duplicate records are summed to give a single output line
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.
The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.
If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.
When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.
TrustScore
4.9
/ 5
2411 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
