If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...

How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up ...

If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...