[Affiliate]
Blog Stats
- 3,317,008 hits
-
Join 3,247 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Sequential number for visible rows only
- Dropdown calendar in Excel
- How to sort bar chart in descending order?
- #Excel Add current selection to filter. What it does?
- SUM vs. SUBTOTAL
- Probably the fastest way to convert formula into value - CTRL C, CTRL V, CTRL, V
- Convert an 8-digit number into Excel-recognizable Date
- Rename column names in a dynamic way with #Excel #PowerQuery
- 20% off Excel and Power BI Dashboard Courses
- Combine contents in a range of cells into a single cell, with no VBA nor formula.
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: EXACT
Three different ways to do case-sensitive lookup
If you do VLOOKUP, you probably know that one of the limitations of VLOOKUP is case-insensitive. It means case is not a consideration in the lookup process, where PETER is essentially the same as peter. Hence VLOOKUP will consider that … Continue reading
wmfexcel 