Have you been faced with the task of counting the number of values on a worksheet based on a specified criterion on Excel, specifically Counting Negative Numbers in Excel? Today we will see how to Count the number of Negative Values (or Numbers) in an Array of Data consisting of both positive and negative values on Excel using: A function Visual Basic Application Code For the purpose of this tutorial, we will be using the table shown below to understand how to carry out this task. This table shows the average temperature of seven cities in the month of April…
Author: Denise Elizabeth
If you use Excel, you will likely come across different symbols and signs at one point or another. And many of them, such as apostrophes, can be useful and meaningful in their own way. Yet, apostrophes can sometimes tend to pop up in some of the most unexpected (and unwanted) places while you are working in Excel. When apostrophes become visible in front of the values within a cell, this can be a perplexing experience – yet it can also present the perfect opportunity to explore more about this common issue that many have faced at some point in time.…
Microsoft Excel is useful to concatenate data from separate cells into one cell. For example, you may have 3 separate columns of first, middle, and last names that need combined: You can do so in 5 different ways and separate the combined results using delimiters (symbols such as dashes, apostrophes, decimals, etc.), spacing, or line breaks (a new line). Without adding a separator, your results will be joined such as: “JohnErinDoe”. For combining multiple cells into a single cell, choose from one of these 5 methods: Flashfill *requires a list or pattern for Excel to gauge TEXTJOIN function *Requires Microsoft…
When working with currency values in Excel, you will see that Excel likes to add in the dollar sign. While this can be convenient in some cases, other times you may not want to include a dollar sign or perhaps you want to use some other currency symbol. Luckily, there are several easy ways to control your currency formatting in Excel. In this article, we are going to review four easy ways to remove or change the currency symbol in Excel. Let’s get started! Here are Four Ways to Easily Remove Dollar Signs in Excel Using the Format Cells Dialog…
When working with data in excel (numbers or text), there may be times where the data has dashes or hyphens that need to be removed. For example, say you have a large group of social security numbers in the following format: 123-456-789. You need to remove all of the “-” symbols and just keep the numbers. If you are thinking about going into the spreadsheet and removing each dash one by one, think again. Removing dashes and hyphens one by one is simply not an option when you have large amounts of data. It is a tedious and time consuming…
When dealing with data that has exponential values, Logarithmic functions are frequently used. When working with log functions, you are going to need to find the antilog at some point. If you are working in Excel, you have most likely noticed that it does not have a function to find the antilog value. This article is written to show you an easy workaround using excel. If you understand the basics of logs and antilogs, this workaround should be intuitive and easy to understand; Let’s first review the basic math concepts behind logs and antilogs, then we will work through how to…
Computer users have been using spreadsheets to organize and manipulate information ever since the appearance of the first personal desktop computers. Information is represented in a two dimensional matrix, with the axes commonly referred to as rows and columns. Each piece of information is contained in a cell, and its coordinates are given as the row and column at which the cell resides. Almost any type of information can be entered in a cell, including numeric, currency, date, time, and of course various text formats. It is customary to give columns labels or titles for easy identification, usually in the…
Google Sheets is a free, web based spreadsheet application. It is part of the Google Docs Editors suite (the other applications being Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep). Being a web based application, one of its advantages is that it allows several users to collaborate on the same document at the same time. While this adds tremendous power and flexibility, while at the same time opening up an array of possibilities, it also creates a problem when two users simultaneously edit or update the same piece of content, each possibly overwriting the other.…