Excel Length Formula
The Excel Length formula is a useful formula that can be used in many different circumstances. I’ll be showing a few of the useful examples of it below. But first let’s take a look at the formula itself: LEN(text) where text is any string you want to find the length of. This formula is really [...]
Match Formula in Excel
The Match Formula in Excel is an easy way to have excel look through an array of values and return the relative position if the match is found. The difference between this and the lookup functions (eg. Vlookup) is it return the position of the item and not the item itself. Let’s go ahead and [...]
Rank Formula in Excel
The Rank Formula that is built into Excel can be a very useful way of speeding up the ranking of several items. Let’s take a look at the formula and see how this can help us out: =rank(number, ref, order) where number is the number whose rank you want to find; ref is a reference [...]
Hyperlink Formula in Excel
I’m going to add this section to the Microsoft Excel Help section (menu on the left) of the website. An excel user contacted me and questioned how to create a hyperlink inside of excel using the value in another cell to as part of the link. The Formula looks like this: HYPERLINK(link_location,friendly_name) where link_location is [...]
Today() Formula in Excel
A common excel formula that can come in handy in many projects with Excel is the Today() Function. The Today() Function is used to return the serial number of the current date. By formatting the cell where the formula is used, it will return the Month, Day and Year of today. One of the easiest [...]
Loading ...