Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Wil will compare TEXTJOIN and CONCATENATE. If you have Excel 2016 then you may be already aware of some of the new functions that are available. One of those functions is TEXTJOIN, and also CONCAT which was introduced in February 2016. I have been using TEXTJOIN recently to replace the CONCATENATE function I used on a regular basis. I get the same results, without the hassle the … [Read more...]
Formula Friday – Fast Formula Fill Using An Excel Table
Hello and welcome back Excellers. Today I want to show you how to achieve a fast formula fill by turning your data into an Excel table. If you want to make managing your data really easy, then I would recommend turning your range of cells on your Excel workbook to an Excel Table. Why Excel Data Tables? Excel Tables really help you filter, sort, organise and make your data easier to view. They also have an ideal structure for the source data of an Excel Pivot Table. If … [Read more...]
A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday
Welcome Excellers to another #FormulaFriday blog post in my 2020 Excel series. Today I am going to show you some Excel formulas. These are a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I will show you an example. I have a set of data below that I want to use in a VLOOKUP … [Read more...]
Excel Tip. Highest And Lowest Selling Price of Product Using MINIFs and MAXIFS.
Today's Excel tip is a question I was asked recently by a subscriber. It was to achieve an easy way to find the lowest and highest selling prices for a range of products. So, Welcome back to another blog post in my Excel tips #FormulaFriday 2019 series. The data set contained sales records for Sales People along with selling prices of goods. The minimum and the maximum price that the Salesperson agreed with the customer per product was needed. This is an easy job for the MINIF and the MAXIF … [Read more...]
Find Missing Values In Excel. Formula Friday
Hello, Excellers welcome back for another Excel blog post in my 2020 series where I share my #FormulaFriday #Excel tips. Today let's look at a really handy Excel formula or a number of formulas that will tell us what numbers are missing in a sequenced data set. Cool huh?. Let's get writing that formula to find those missing values in Excel. We are going to use a number of Excel formulas. We will begin with the logical IF Function. Here is my sample data set. I can clearly see that some … [Read more...]
- 1
- 2
- 3
- …
- 31
- Next Page »
Recommended Excel Resources
