Understanding Basics A formula is like a special code entered into a cell. It performs a calculation of some type and returns a result that is displayed in the cell. A formula always begins with an equal sign and can contain any of these elements: Mathematical operators Cell references Values or text functions After you […]
TODAY() function returns the serial number of the current date. This function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals. For example, if you know that someone was born in 1990, you might use the
The TEXT function let us change the way a number appears by applying formatting to it . It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. In its simplest form, the TEXT function says:=TEXT(Value you want to format, “Format
You can easily highlight the cells containing duplicate values in a column by using a feature called “Conditional formatting”. This option is available in Home menu. Here is the image showing the way you can use the option. This was the short and brief demo showing the way to find the duplicate values. I hope
Find Duplicates in a column in MS Excel Read More »
