Archive for the ‘Excel’ Tag

Flagging duplicates in excel

Monday, July 20th, 2015

Excel is a useful tool in matters such as listing systems which need migration to new domains. Problem is duplication of records.  Rather then sorting and reviewing each entry; why not flag each duplicate found?

  • To do so:
    1. Select the range of cells you wish to test. …
    2. On Excel’s Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.
    3. Click OK within the Duplicate Values dialog box to identify the duplicate values.
    4. Duplicate values in the list will now be identified.
  • Identifying Duplicate Values in an Excel List | AccountingWEB…/221103

Excel can’t paste formatted text.

Saturday, April 21st, 2012

I had an odd excel issue today.  My co-worker asked if I had seen a situation where you loose the ability to paste formatted text to a spreadsheet.

I had a look at his office 2010 setup and nothing obvious was missing and there were no error messages to suggest a problem.

I right-clicked a cell and selected “Paste Special..” and found the only option left was unicode text.

Even though I knew it would not solve it; I ran a repair on office.

I checked around the Net and found a few suggestions to edit the cells via vba through the alt-F11 command but they did not solve the problem.

I searched the Microsoft site and found an article  about the clipboard loosing the ability for format pasting.

The problem seems to center around the use of Skype’s Click to Call.

This seemed odd but we tried disabling it on the browser and the add-ons for Excel and Word. The problem remained.

We ended up uninstalling Click to Call and after restarting the browser and Excel; we found the ability for formatted pasting had returned.

Lesson of the day: The integrated clipboard can cause problems after installing new software.