In daily spreadsheet tasks, you will encounter various types of data. Suppose you have a column of numeric data of formatted in 3 decimal points like the table below: Suppose you need to use the WHOLE number parts of the data in column C (Average) in the table above, how would you do it? Using the Round Function If you vaue the decimal digits of your data and want to include them in the computation of the resulting whole numbers, you need to use the ROUND() function. In Excel, the… Read More
Posts tagged Excel Tips and Tricks
How to extract the unique values or data in a column with duplicate data
Suppose you have a spreadsheet at work and one of the columns contain a huge list of account numbers being exported from your company’s accounting system that contains a lot of duplicates. And you are tasked to extract the UNIQUE account numbers in this huge list. If the list is just a short one, like 50 rows or 100, you can easily use the Conditional Formatting that highlights all duplicates, then you can manually delete the highlighted duplicates until no marked cells are left. This can be done easily with… Read More
Microsoft Excel: Using Data Validation to provide drop-down selection menu
In Excel, there are various ways to provide a drop-down menu in a form or in cells. With drop-down menus, also called combo boxes, you can select an option based on pre-selected data. Samples of data where drop-dowm menus will be useful are gender (Male and Female options), Status (Single, Married, Divorced, etc options) and many others. The major reasons for providing a combo box or drop-down selection menu includes the following: On the other hand, combo boxes or drop-down selection menus are only applicable when: In this article, I… Read More