Excel Tips
September 5, 2022
My manager wants me to add employee pictures to the department phone list. I need the pictures to sort with the data.
Sort All Red Cells to the Top of a Report »
September 2, 2022
I’ve read through a 20-page report and marked a dozen cells in red. I need to audit those records and would like to sort the red cells to the top of the report.
Sort a Report into a Custom Sequence »
September 1, 2022
My manager wants me to sort a report geographically. My annual report typically lists results from the United States first, then Europe, and then Australia. I need to sort so that the countries appear as United States, England, France, Germany, and Australia.
August 31, 2022
I have a column with values such as Monday, Wednesday, and so on. When I sort this column in ascending sequence, Friday comes before Monday. The same problem happens with month names, which sort as April, August, December, and so on.
No Tiny Blank Columns Between Columns »
August 30, 2022
My Manager wants tiny blank columns between the columns.
How to Fit a Multiline Heading into One Cell »
August 29, 2022
My manager requires that I format a report to have the heading “Prior Year” split, with “Prior” in one row and “Year” in a second row. How can I make my manager happy while also following the list format rules?
How to Set up Your Data for Easy Sorting and Subtotals »
August 27, 2022
I want to be able to use the powerful data commands such as Sort, Filter, Subtotal, Consolidate, and PivotTable. Is there any special way I should set up the data to begin with?
Replacing a What-If Data Table with One Formula »
August 26, 2022
This example uses Broadcasting to calculate a number of monthly car payments using the PMT function.
Generating an Array of Random Numbers with RANDARRAY »
August 25, 2022
Traditionally, =RAND() returns a decimal greater than or equal to 0 and less than 1. Originally, RANDARRAY would only return RAND. A change in February 2019 added the Min, Max, and Integer arguments to allow RANDARRAY to simulate RANDBETWEEN.