Topic: Excel tip

[BillB]

Here’s an article I found when I asked Excel Help how to identify duplicates . I also learned at least 2 more things not necessarily restricted to finding duplicates. Check it out at:

http://office.microsoft.com/en-us/excel/HA011366161033.aspx?pid=CL100570551033

I learned how to:

1)                   Mark duplicates
2)                   Use formulas in conditional formatting
3)                   Set a conditional format based on the contents of a different cell or range
4)                   Use full column reference in a logical or lookup formula

And, I learned all this while on someone else’s clock!
--------
Come to the MS Office SIG to share and learn tips like this.