If you find yourself always merging worksheets of client data and know that there must be duplicates, here is an easy way to find those duplicate entries. Select the range of cells On the menu bar, click on format, conditional formatting Under Condition 1, select Formula is In the formula =Countif (column range you are [...]
Want a way to quickly enter today’s date? Press Control + ; (Ctrl and semicolon simultaneously). Now if you also need to enter the time just press Control + Shift + : (Ctrl, shift, colon simultaneously). Another way to get the most of those keyboard shortcuts.
You are working on a fairly large spreadsheet and you just want to know the total of a certain group of numbers, perhaps of one product available in different sizes or sales numbers for a particular customer. There is a quick way to get the value without having to key in a formula. Click once [...]
Do you add data into Excel and it contains extra spaces that you do not need? Or do you need to display numbers in a different format than how they currently appear? To remove ALL spaces from a cell (as the TRIM function leaves one space in the middle) using Find and Replace. Select the [...]
A duplicate row (also called a record) in a list is one where all values in the row are an exact maatch of all the values in another row. To delete duplicate rows, you need to filter a list for unique rows, delete the original list, and then replace it with the filtered list. The [...]