When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Excel mimics the capitalization and punctuation you use, so enter the names exactly as you want them to appear. Begin typing the next first and last name in the next cell in column C.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

If you don't have an existing file, use the blank worksheet in Excel. Type a zero in the first row of your column and drag your mouse down to the last row of the column to autofill it with zeros.

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...

Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook ...

Q. I have a report in Excel containing names of employees, including their Social Security numbers. I’d like to print the report showing only the last four digits of each employee’s Social Security ...

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.