thedatawizard

Finds and marks duplicates, allowing you to sort off of the "duplicate" label for further processing.

Show how to add the DEVELOPR Tab and find your XLSTART path.

Building a single string with different separators from a list of selected items.

Useful for filling in blank rows where downloaded data shows only a value on the top row and leaves the rest blank.

Copy a Cell Then Use This Routine to Follow Your Pattern Column to Skip Blank Rows

Removes Empty Rows From Your Selection

Allows you to use up to 9 Columns to Sort your Data

Sort your data based on the Cell Background and Text Color

Applies Visual Space Once You Find an Item

Inserts Rows for Visual Break Each Time a Cell Value Changes

Find A String NOT EQUAL To The String You Select

Return Multiple Items With This VLookup

Routine creates a unique list from the select items

Compare 3 Division Order decks, all appearing on the same tab.

Compares two name sets found on two separate tabs

Compare Two DOI Decks on Two Tabs

Video quickly shows how to display the DEVELOPER Tab and also how to find the location of your XLSTART path.