Kara asks: Do you have a trick for the subtotal function?
In a “subtotal by” task where I use three fields (ID / Name / Amount) to get the total amount, Excel makes me choose between ID or Name for “at each change in” but I’d like to retain both so I currently perform data gymnastics to concatenate the ID and Name fields…..and then after using the function, I perform more gymnastics after selecting level 2, “go to special” / visible cells only on the subtotals, paste to another sheet, and then split the ID and name back out Continue reading “Excel Subtotal By ID And Name 2381”
![](https://i0.wp.com/bonbonsguide.com/wp/wp-content/uploads/2023/02/orzlvhcT9vs.jpg?fit=900%2C506&ssl=1)