Thread
: [Solved]
formula taking long time to distinct word
View Single Post
03-18-2012, 03:30 AM
Colin Legg
Windows 7 32bit
Office 2010 32bit
Expert
Join Date: Jan 2011
Location: UK
Posts: 369
Excel's built-in Advanced Filter can extract a list of distinct values very efficiently. I recommend that you adjust your workbook so it uses that instead.
Colin Legg
View Public Profile
Find all posts by Colin Legg