Categories
Daily Workflow

Highlighting Duplicate values in Excel

Sometimes such a simple thing makes the difference when you’re staring at a lot of data in Excel. I always set this just in case I’ve got some duplicate records that were missed on a data dump.  

Categories
Website Development

Automatically create a URL/HREF in an Excel field

You output 5000 rows of data into Excel for a client to review and need to make them all HREFs. The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article. We have this: ArticleID URL 456 And […]