98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Standardising outputs to deal with missing/duplicate data
Standardising outputs to deal with missing/duplicate data
Resolved · Low Priority · Version 2003
Fri 31 Oct 2008, 15:45Delegate Matthew said...
Matthew has attended:
Excel VBA Intro Intermediate course
Standardising outputs to deal with missing/duplicate data
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |
