Have a lot of data in an Excel worksheet, and consider some of the rows to be duplicates? Here is how to determine whether a row is a duplicate.
380 total views, no views today
excel.tips.net
Excel.Tips.Net: Clearing and Deleting Cells
When editing Excel workbooks, one of the most common actions to take is to clear or delete cells…although the difference between the two actions is clear as mud.
327 total views, no views today
Excel.Tips.Net: Filtering Columns for Unique Values
It is not unusual to acquire or develop Microsoft Excel data tables that have duplicate values in a column. If you want to see only the unique values…
257 total views, 1 views today
Excel.Tips.Net: Deleting Every X Rows without a Macro
When working with data retrieved from another source—such as another user or from an external program—you may have a need to remove certain rows from the data. It is not unusual, for instance, to have the need to remove every third row or every fifth row. The following general steps allow you to delete every X rows without using a macro.
1,009 total views, no views today
Excel.Tips.Net: Converting Numbers Into Words
There are times when it is beneficial, or even mandatory, to spell numbers out.
346 total views, no views today
Excel.Tips.Net: Adding Leading Zeroes to ZIP Codes
When you import ZIP Codes from a text file into an Excel workbook, it is not uncommon for Excel to translate the values as numbers rather than as ZIP Codes.
250 total views, no views today
Excel.Tips.Net: Maintaining Formatting when Refreshing PivotTables
When updating the data on which the PivotTable is based, and then refresh the PivotTable, all your formatting work may go away.
201 total views, no views today