How to compare two columns for differences in Excel

How to compare two columns for differences in Excel

The comparison involves checking if one list matches the other. Excel is a powerful tool for checking if one column matches the data in the other column. This is because excel consists of cells that are arranged in columns. Therefore, few workarounds and formulas can be used to check the comparison between two or more … Read more

In Excel, How to sum only positive or Negative numbers – Formula

How to sum only positive or Negative numbers – Formula

When working with Excel datasheets, you may often need to conditional add the data. You may need to sum only the positive numbers or sum only the negative numbers in Excel. It can easily be done using the built-in formulas within Excel. Below, we guide you on how to do this. Let's look at the … Read more

How to Hide Formulas in Excel

How to Hide Formulas in Excel

It is easy to get formulas in Excel; by clicking on the cell or, rather, by selecting the Formulas ribbon. It gives you the formula you are looking for and the step-by-step evaluation walkthrough of the formula. However, when you are working on complex calculations, it is important to hide the formulas to avoid cluttering … Read more

How to generate random numbers in Excel

How to generate random numbers in Excel

Random numbers are automated generated numbers that are displayed without an order. When working on a worksheet, the user may need to generate random numbers to perform various tasks. This is achievable due to the existence of two worksheet functions that are responsible for generating random numbers. They include The RAND function and the RANDBETWEEN … Read more

How to prevent Excel from rounding off numbers

How to prevent Excel from rounding off numbers

Microsoft has designed excel in a way that will be efficient and easy to use for its users. However, some of the features of Excel can be counterproductive and thus reducing its efficiency. Rounding off large numbers is one of these features that are times counterproductive. When dealing with large numbers on excel cells, excel … Read more

How to combine data from 3 cells into one

How to combine data from 3 cells into one

At times we work with large worksheets in an Excel workbook. It becomes a dreaded issue when you want to combine all your data, as most people automatically think it will mean retyping all that text. Now you can breathe a sigh of relief because, when you are working with data in Excel, it is … Read more

How to count cells that contain only N character

How to count cells that contain only N character

Excel is a powerful and very helpful Microsoft program for data analysis and documentation. OK is a spreadsheet program with many columns and rows, and sometimes we need to know the number of cells and the number of columns or characters within the cell. As we all know, every cell contains one point of data … Read more

How to Remove Characters in Excel Cells

How to Remove Characters in Excel Cells

Formulas are key in getting things done in excel. One can apply formulas to manipulate texts, work with dates and time, count and sum with criteria, create dynamic ranges, and dynamically rank values. Explained below are formulas one can apply to remove characters in excel cells. 1. The Array Formula Assuming we want to eliminate … Read more

Excel formula for percentage

Excel formula for percentage

Anyone who constantly works with numbers probably also works with percentages. Calculating percentages apply in many areas of our day-to-day and everyday lives. Some of the areas we apply percentages include; discounts, percentage changes between different values, and percentage of correct answers in a test or survey. Lucky enough, it is easier to calculate percentages. … Read more