Celebrate 'The VLOOKUP Book' birthday with us. Get 50% discount on the e-book today & tomorrow (30 & 31 October only).

Click here for details

About me: Hui

Hi. My name is Ian Huitson but everyone calls me Hui

About_Hui_MVP

I work as a Consulting Mining Engineer in Perth, Australia. I have a Bachelor of Engineering Degree (Mining) from the Ballarat College of Advanced Education in Australia.

I am passionate about scheduling and budgeting, simulation and mathematics but more importantly is their application to real world problems.
I have been using spreadsheets since Visicalc and have used Lotus 123, Open Access, Quatro Pro, 20/20 and Excel.

I was first awarded a Microsoft MVP (Excel) Award in October 2013 for my contributions to the Excel community. It was re-awarded in October 2014.

I should add that these contributions are mostly here at Chandoo.org and at Excel Hero, see below.

 

Why do I start equations with a =+ ? Because Open Access used to start equations with a + and it has just stuck, although I am getting better at not doing this.

Open Access also had a great function ! which I often wish Excel had. In use you could do something like convert Celsius to Fahrenheit Enter =(9/5)*!+32 into a cell. Then enter say 20 into the same cell and the cell would display 70. The ! took the input directly into the cell and used it in the formula and displayed the answer in the same cell. The cell still has the equation.

 

I am married to Eva, and have 5 children. You can see a few wedding snaps here.

In 2009 I took 9 months off work and we did a bit of traveling and during this time I started answering questions on Chandoo’s, newly setup, forums where I have helped out ever since.

In May 2010, Chandoo asked me would I write an article on Monte Carlo Simulation after I had described the process in a post. This resulted in the well received Data Tables & Monte Carlo Simulations in Excel a Comprehensive Guide. I have written a further 70+ posts since then as well as Starting and Authoring the Formula Forensics Series.

I hope you enjoy my contributions below:

 

Posts by Hui…

Hui’s Calendar Tool (New)

Countif() Quick Tips (New)

How to Solve an equation in Excel

Check Cells for Equality – Follow Up [Quick Tip]

How to make a Spoke Chart (Custom Excel Chart)

Displaying Text Values in Pivot Tables without VBA

In-cell Text format – 2 Quick Techniques 

Custom Number Formats (Multiply & Divide by any Power of 10)

Cleaning Up Imported Data – A Recent Case Study

Fancy Posts (Not fence posts)

A technique to quickly develop custom number formats

Hui’s Excel Report Printer (Popular)

Custom Chart Axis Formats (Part 2)

Selective Chart Axis Formats

We want your Ideas – Results

3D Dancing Pendulums (Very Popular)

Automating Repetitive Tasks

We want your ideas

Analyse Data like a Super Hero

Advanced Sumproduct Queries

LOST Excel Functions

Using Solver to Put items into Buckets

Dummy Data & random Functions

How to Make a 5 Star Chart (Like Amazon.com)

Beam Me Up Scotty – Excel Hyperlinks

Form Controls – Adding Interactivity to Your Worksheets

Are You Trendy? (Part 1) – Trendlines and Forecasting in Excel) (Popular)
Are You Trendy? (Part 2)
Are You Trendy? (Part 3)

Worksheet Properties via a menu

Data validation using an unsorted column with duplicate entries as a source list

The Selection Pane

WordArt in Excel

Indian Currency

Resource Scheduling

Highlight Excel Chart Data Points

Hiding Error Messages

Analysing Large Data Tables

Export Excel Data to a Word Report (Popular)

Extract a Unique list using a Pivot Table

Data Tables, MonteCarlo Simulations and Mandelbrots (Very Popular)


Formula Forensics Series

Formula Forensics No. 001 – Using an Array to Find and Count the occurences of a word

Formula Forensics No. 002 – Joyce’s Question

Formula Forensics No. 004 – Fred’s Problem

Formula Forensics No. 005 – Zebra and Checker Boards

Formula Forensics No. 006 – Palindromes

Formula Forensics No. 007 – Sumproduct

Formula Forensics No. 008 – Elkhan’s MaxIf

Formula Forensics No. 009 – Pradhishnair’s Chainage

Formula Forensics No. 010 – Count How Many Times a List of Values Occurs in a Range

Formula Forensics No. 011 – Lyke’s Formula  

Formula Forensics No. 012 – A Neat Formula

Formula Forensics No. 013 – On Vacation (EHA Showcase)

Formula Forensics No. 014 – Faseeh’s Formula

Formula Forensics No. 015 – Cornelia’s Price Rises 

Formula Forensics No. 016 – Suzannes DJIA Average

Formula Forensics No. 018 – Retrieving the Nth number from a Range with Gaps

Formula Forensics No. 019 – Extract Time from Strings

Formula Forensics No. 020 – Bhavik’s Monthly Workingdays Formula  

Formula Forensics No. 021 – Extract the 4th Slash

Formula Forensics No. 022 – Adding up the Odd Numbers between 1 and 100 

Formula Forensics No. 023 – Counting and Adding Values in Filtered Tables with Criteria

Formula Forensics No. 024 – Is my Number a Prime ?

Formula Forensics No. 025 – Count Unique Values in a Range

Formula Forensics No. 026 – Highlight Only Duplicate Entries

Formula Forensics No. 027 – Remove Leading Zeroes 

Formula Forensics No. 028 – It’s Just a Jump to the Left

Formula Forensics No. 029 – SumIf with Inconsistent Column Layouts

Formula Forensics No. 033 – Interpolation 

Formula Forensics No. 034 – Extract words from a Cell where they exist in a list

Formula Forensics No. 035 – Average the last 3 values greater than 0 (New)

Formula Forensics No. 037 – How to Subtotal a Filtered List (New)

 

Posts about Hui…

1,000 Forum Posts

Happy Birthday Dashboard

What’s Your Excel Age?

Story of 3 Excel Ninjas

Chandoo visits Perth

Chandoo.org produces its Second MVP

 

Hui’s Excel Work at ExcelHero.com

Motion Induced Blindness (New)

Excel Dancing Pendulums (Popular)

Lilac Chaser

Counter-Intuitive Illusory Contours

M. C. Escher

Two Sinusoids

Cafe Wall

Curry’s Paradox

 

Acknowledgements:

In the early 2000′s I used to be a Beta Tester for John Walkenbachs PUP utilities.

During this period John and I would correspond regularly.

When I developed the Excel Mandelbrot without VBA I sent John a copy

Unbeknown to me John acknowledged the effort with this: Excel 2007 Bible

 

References from Other Sites:

Newtonexcelbach

 

Closing:

I will be continuing to write small posts of a practical nature here at Chandoo.org and look forward to your input and suggestions.

If you have Excel questions please direct them to the Chandoo.org Forums where they will be looked at quickly by myself or any of a number of other Excel Ninjas or Excel users.

 

Donations:

If you are appreciative of the above volume of work and would like to assist me in future endeavors or you feel like thanking me through a monetary donation:

Small Donate Button

Contact Hui:

For other general use please email me at:

ihuitson [at] gmail [dot] com

Please Do Not  befriend me on Facebook, Linkedin etc. I reserve those sites for my direct friends and true business acquaintances.  I don’t want to offend you by not accepting your request.