All articles in 'Posts by Hui' Category

Recently in the Chandoo.org Forums, MR06 asked the question, “I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes.” MR06 was using Goal Seek to change the equity input […]

Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.

Chandoo.org is looking for your ideas!
What would you like to see discussed in future posts at Chandoo.org ?

Lets take last weeks Stacked Bar/Column Chart and add some high-performance steroids.

Learn how to convert a Roman Numeral to a Number using this nifty formula. No VBA required.

Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial

A while back I developed a solution to a Chandoo.org Forum question, where the user wanted a 4 level doughnut chart where each doughnut was made up of 12 segments and each segment was to be colored based on a value within a range. If the values changed he wanted the chart to update, Conditional Formating like:
This post looks at how this was achieved.

Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.

Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…

Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?

I haven’t, but in this post I will show how you can add it to your worksheets.

Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.

Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks

Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Lets look at how to apportion sales according to multiple criteria

Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)