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

In order to make Windows XP ignore new wireless networks, there must be some sort of registry tweak or something, right? There must be some way to force the manual setup of new wireless network connections in Windows, right? Let’s find out… After a bit of Googling came up with these:

http://antivirus.about.com/od/securitytips/ht/wirelessconn.htm
This one may be true, but on the system I checked the checkbox mentioned was not ticked.  Not to mention, this does not keep the wireless adapter from finding, or scanning for, new wireless networks and reporting that they are in view.

Posted under Microsoft, Network, Wireless