Heartland Technology Solutions

WorryFree™ IT Managed Services Reduces Cost and Downtime

Don't be overwhelmed by the flood of tasks necessary to manage your IT network.

Watch our video to find out how our experts will give you your time back!

Call us now at 888-296-3619!

24% Lower IT Costs Proactively manage your network
Lower IT Costs
88% Less Network Downtime Always be up to date
Less Network Downtime
42% Higher Staff Productivity Focus on work, not computer woes
Higher Staff Productivity
based on an IDC study

Latest from the Blog

Happy Thanksgiving from HTS!

We hope that this Thanksgiving season finds you with plenty of reasons to give thanks!

Use Conditional Formatting to Find Duplicates in Excel

conditional formatting in Excel

Conditional Formatting is a very handy tool in Excel, especially when working with lists that include companies and addresses. Often if you are working in a list you want to find duplicates to remove, but maybe the company names are the exact same, or there are so many in your list it will literally take hours upon hours to complete. This is where Conditional Formatting will come in handy for you.

In our example the spreadsheet is a list of companies with contacts, phone, email and address. I don’t want to send the same company my mailing so I want to find duplicates.

Step 1: Highlight column you wish to find duplicates in.

HP Business Partner