Dynamic Chart Label Million to Billion with Conditional Formatting

https://youtu.be/wjJUN9dodfo

You want dynamic labels for your charts or graphs? For example, when showing sales, if it’s over a million bucks you don’t want the chart label to show 7+ digits. You just want it to show something like 1 M. But if it’s less than 1 million, like 500,000 you want it to show 500K. AND you want it to be dynamic cause your data changes so often.

Think you must do this manually? NO!! There’s a way to do it with a custom format hack. I’ve even through in a bonus tip near the end.

Key Word Search to Bring Back Multiple Results

https://youtu.be/4S8WIf_Hskk

Do you create dashboards or templates and want to have a mini search bar or search cell...Something like a mini google in your Excel sheet? Imagine having a cell where you can type some keyword or part of a word and expect it to bring back records that match the keyword. It’s not a full fledge search engine, but it is a neat thing you can do with just a few combinations of the newish dynamic array functions in the latest versions of Excel. Having a keyword search capability and using it for lookups is just another cool way you can use Excel to help you make spreadsheet data useful. Whether you’re doing it for yourself or have a template to send your users, think of this as a neat little tool that hopefully make your job easier.

Lookup to Find Multiple Matches

https://youtu.be/3rI65uIMMko

If you’ve done lookups with VLOOKUP, INDEX/MATCH or even the new XLOOKUP, it usually just brings back one record or one match per cell. But what if you wanted a lookup to find multiple matches? Think you’d have to write crazy long formulas or VBA code? Well with a neat dynamic array function in M365, it’s just a simple combination with other functions that will take you less than a couple minutes to put together...maybe even less that one minute, once you understand how it’s done.