14:00
This Micro Tutorial demonstrates how and when in alternative to VLOOKUP, use INDEX MATCH.
0 Comments
Suggested Videos
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
The Data Visualizer (DV) add-in for Excel provides a powerful, fast way to build flowcharts and swimlane diagrams from data.
And you don’t even need a Visio license to make this magic happen!
Suggested Courses
Next Video:Using Excel's Lambda Function