- 2,720,398 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Be cautious when using XLOOKUP
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to replace value with a value from another column in Power Query
- Insert a text string into a specific position of another text string in #Excel
- Perform VLOOKUP with 2 lookup values
- When unhide row doesn't work...
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Dropdown calendar in Excel
My YouTube Channel
- My Tweets
Tag Archives: SUBTOTAL
…that works even when filter is applied. The situation: We have a table that we would like to apply color banding based on groups. We can achieve this by inserting a helper column to identify the sequence of each group, … Continue reading
This is about using SUBTOTAL and CELL function to detect whether a row and a column is hidden respectively. When rows are hidden by Data–>Group, you will see a +/- button on the leftmost of spreadsheet to remind you that … Continue reading
How to display a column of sequential number to visible rows only? Got this question from a friend. Her task is simple as shown below: I guess many people wanted to achieve the same thing but have no idea at all. Are … Continue reading
How to insert thousands of rows for each change in item in a column? And then give a subtotal of each item? Long long time ago (>10years) when I was only an Excel newbie, a friend asked for help. She … Continue reading