Excel Magic Trick 1222


Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format?

DESCRIPTION

Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg:
(00:10) Problem Setup
(01:12) Customer Number Formatting to show Number with the units “kg”. Custom Number Format to Display units such as “kg” for Number Data.
(02:45) Array Formula that uses the Functions SUBSTITUTE and SUMPRODUCT. Extract Numbers from Alpha Numeric data with SUBSTITUTE. Add array with SUMPRODUCT.

WORKBOOKS




Be the first to comment

Leave a Reply

Your email address will not be published.


*