Excel Video 369 introduces the TRUNC function which drops everything after the decimal. TRUNC may not be quite as elegant as ROUND is, but it may come in handy for you. Watch how I combine SUM, ABS, and TRUNC in one array to calculate the sum of the absolute value of the truncated numbers.
We’ve played with SMALL and arrays in Excel Videos 360 through 362, but here’s another example you might find useful. Watch how I can use SMALL to sort and find the top three appeal issues that I need to work on first. SMALL and LARGE are great ways to sort data on the fly.
I have a new dataset to discuss more array tricks next time. I look forward to seeing you then.
