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’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

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.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.

Product Function Excel provides the PRODUCT () function to calculate the original value by the percentage markup. Place your original value or cost into column A and label it with a description.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

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.