Code For Excel And Outlook Blog

Format SSN - Updated formula

Wednesday, February 20th, 2008 113 views

Here is an update to the code I have posted on the site at Format SSN I realized that the last part of the formula doesn't check for dashes. Here is the updated formula: =IF(AND(LEN(A4)>6, LEN(A4)9, NOT(ISERROR(FIND("-",A4)))),A4,LEFT(A4,3)&"-"&MID(A4,4,2)&"-"&RIGHT(A4,4))) Notice the addition of NOT(ISERROR(FIND("-",A4))) in the second IF formula. If the formula already has dashes in it, ...

Posted in Excel, Formulas | No Comments »

Counting Unique Occurrences in an Excel Spreadsheet

Monday, January 28th, 2008 19 views

This formula, entered as an array (Ctrl-Shift-Enter) in a single cell, will show you if there any duplicate entries in a given range (in this case, A1:C100). It is wrapped in an IF function to provide a friendly message; a kind of in-cell error handling, if you will. I usually ...

Posted in Excel, Formulas | No Comments »