Whether you're building a model or trying to simulate a scenario within your analysis, at some point in your Excel career, you're going to need to use a randomized set of data.  If you need to create a purely random set of numbers, with no specific constraints or parameters, you can just use the RAND ... Continue Reading >>
Five Ways to Find and Remove Duplicate Values in Excel For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values.  Some people refer to this process as de-duping.  The main reason this is necessary in data sets ... Continue Reading >>

Related pages

how to hide a formula in excelhow to vlookup in exceldifferent types of formulas in excelmatch rows in excelbins in excelexcel shortcuts in pdfcumulative chart excelfilter shortcut excelvlook up function in excelexcell countifexcel label graphhotkey excelexcel stacked bar chartvirtual lookup excelmba in uclavlookup multiple instancesrandom vba excelexcel formula error messagesvlook formulaexcel vba randomizepractice excel formulasexcel vba application.matchexcel concatenate arrayvlookup stepshow do i do a vlookup in excelidentify duplicates in excelrandom number selector exceladvanced excel formulas and functions xlshow to use excel to compare two lists of datahow to check duplicate values in excelvlookup 2 criteriamicrosoft word insert check markucla gmat scorevirtual lookup excelhow to randomize numbers in excelexcel spreadsheet modelingvlookup function excel 2013macro formula excelindex match formula in excel 2007ucla mba admissions statisticshow to add error bars in excel 2013excel erase duplicatespopular excel macroszs associates employee benefitsformula lookupadding macros in excelhow to insert a tick in excelhighlight duplicate values in excelhow to write tick mark in excelvlookup formula example excel 2007excel important shortcutsvba offset selectionto learn excel formulasexcel nested functionhow to insert tick in excelcondition formula in excelexcel function and formulasexcel ranges in formulasexamples of if statements in excelis there a way to delete duplicates in excelwhat is a vlookuphow to create bell curve in excelind3x hrstudent assignment sheet templatemultiple if formulashow to make a stacked bar graphmaking a line graph in excelcorrect mark symbolcounting entries in excelinsert check mark in excelexcel delete shortcutexcel formula to find duplicates in a listexcel 2010 vlookup multiple criteria