Norse Technologies Knowledge Base Free Knowledge Articles

Using conditional formatting one may easily show duplicate values in any chosen range of data. Find all duplicate values, and highlight any values that appear more than once.

=COUNTIF(A:A,A2)>1

This is the meat, and here is how:

• Highlight the cell to work on.
• Click Format > Conditional Formatting
• Set Formula Is
• Enter the formula above, replacing the ranges as follows:
  • (A:A means that it will look inside the entire A range. Replace this with your own range, e.g. B3:B5 or CC:CC
  • ,A2) means to count how many times the value in A2 appears in the designated range. This needs to match the cell you are currently working on.
• Then set the format you want to see when the count of identical values existing in the range is greater than one. This value can be altered to a higher number in order to highlight cells that have more than two duplicates, e.g. change it to be >5 to highlight the cell when at least 5 cells have the same value as the current cell, including this cell itself.
• Copy the formula only to other cells in the range. To do this, copy the current cell, then Paste Special and choose Formulas and paste into the other cells in the range.

An excellent tutorial is at MREXCEL.COM, and thanks to that site for this knowledge and info.

Posted under Excel, Microsoft, Office

How to Use Microsoft Excel to Trim All Characters To The Right Of The First Occurrence A Specific Character:

This is a handy technique to trim all content in a cell that appears to the right of a particular character. For instance, to delete all content to the right of the first left parenthesis in the A1 cell:

=LEFT(A1|FIND(“(“|A1)-1)

Replace the character in the double quotes witht the character that is to be found and trimmed out along with all text to the right of it.

To trim all text to the right of, but not including the character, remove the -1 from the formula equation.

Posted under Uncategorized

mstsc \\hostname /console

Microsoft

Posted under Microsoft

Using Office XP, also called Office 2002, could limit you to a 2 gigabyte file size for postoffice .PST and offline storage .OST files.

Microsoft has posted an article addressing this problem, and it recommends updating to the latest Office XP Service Pack. This was performed on a system today, and the successful SP3 update did not remove the 2 gig limitation.

Posted under Microsoft, Office