BEFORE OPENING the Excel-Benchmark-Tester.xlsm Macro Enabled sheet:

Open up Blank Excel Workbook. Go to Formulas tab and at far right are Calculation Options - Choose Manual. Go to File > Options > Formula and set to Manual Calculation and Uncheck Recalculate before save, so you can save results in the sheet without long wait recalculating.

Now open the Excel-Benchmark-Tester.xlsm and the first time you will have to enable content (trust) or Unblock in the File's properties. The macros are for the manual calculate from that Microsoft page because by default Excel AUTO-Calculates. Next Click the 'Calculate Formula Time". When you have three scores, Click in the average score cell and click 'Refresh Average'.


(Dynamic count unique - MULTI-COLUMN)
THE FORMULA COPIED DOWN TO ALL ROWS:
=IF(COUNTIFS($B$2:$B2,B2,$A$2:A2,A2)=1,1,0)
Formula result gets bigger and slower the further down it goes.
It is checking all rows above it as well as current row.

CURRENTLY 250,000 rows but can be increased or decreased by copying or deleting rows.
Column A - 50,000 Unique Accounts
Column B - 13 Unique LOB's

Both can be present multiple times, hence the calculation.
1=TRUE, It hasn't been counted yet (First Count, UNIQUE)
0=FALSE, It's already been counted
