- 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
Tag Archives: MOD
How to limit user to input time at 15-min intervals, i.e. 00:15, 00:30, 00:45, 01:00, etc.? We talked about how to limit user to input Time in the previous post. Let’s go one step further with Custom Data Validation, where you … Continue reading
How to convert something like 1200 into 12:00? For easy sake of input, we often input 24-hr time as four digit number like 930 for 9:30, 1815 for 18:15 etc. However, if time is input in this way in Excel, … Continue reading