Tag: Excel

Highlighting Duplicate values in Excel

Published on May 20, 2015 Author JFLeave a comment

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.

Automatically create a URL/HREF in an Excel field

Published on May 17, 2015 Author JF1 Comment

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… Continue reading Automatically create a URL/HREF in an Excel field →