Split The First And Last Name With A Formula
How to split first and last name from full name with space
Recent posts
Get The Week Or Fortnight Ending Dates With A Formula
These formulas are great for when you have to find the week ending date or even the fortnight ending date for a specific item. Week ending dates don’t have a...
Indirect Sheet Referencing To Calculate Ranges
The INDIRECT function returns a reference to a range. You can use this function to create a reference that won’t change if row or columns are inserted in the...
Calculate Total Sales With An Array Formula
If we had to calculate Total Sales the normal way, we would have to create a ‘helper column’ for the Totals column and then enter a formula to Sum all the To...
Top Values In A List
From a list of 30 people with an assigned value, generate a smaller list that are the top n values in that list.