Excel tips: remove duplicate rows and convert hex numbers

1. Remove duplicate rows:
In Microsoft Office Excel 2007, you have several ways to filter for unique values or remove duplicate values:
To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.
To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.
To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
Ref: http://office.microsoft.com/en-us/excel/HP100739431033.aspx

2. Convert hex numbers:
Syntax
HEX2DEC(number)
Number is the hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Ref: http://office.microsoft.com/en-us/excel/HP052091111033.aspx

3. Remove "0x" for hex number:

An easy way to get that x out, would be go to Data->Text to Columns, choosedelimited, and select the "Other" box and type in "x" for the delimiter.

http://www.excelforum.com/excel-worksheet-functions/401606-can-i-use-hex2dec-with-cell-references-vs-numbers.html