- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Copy data from strictly-protected sheet
- Advanced vlookup - wildcard characters "?" and "*"
- Advanced vlookup - Text vs. Number
- Show number in thousand (k) or in million (M) by using custom format
- Simple trick to look (hack) into hidden sheet
- 2D SUMIF with two variables – one on column and one on row
Monthly Archives: November 2016
If you have been following my blog for more than three months, you should have read this before. If you wonder why I am reposting it again and again (Yes, this is the 3rd time I write about Mynda’s Excel … Continue reading
SUMIF is a handy but helpful function. The syntax is simple: =SUMIF(range,criteria,[sum range] What it does is quite straight forward indeed. In the example above, it instructs Excel to look into the range (A2:A7), look for the matching criteria, which … Continue reading
If you do chart in Excel, you may have encountered this: You clicked on a chart object, tried to move it just a little bit to the right by pressing Right Arrow key a few times… Instead of the chart being moved … Continue reading
As you may be aware of, I haven’t written a real blogpost recently. I was super busy at work in the past month. No surprise. There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading