Formula Forensic No. 021 – Find the 4th Slash !
No, Not that Slash !
How do I find the 4th Slash in a text string?
Today at Formula Forensics we take a look at 4 different methods.
Displaying Text Values in Pivot Tables without VBA
Pivot tables are a great way of summarising and consolidating data to produce summary reports.
One of the main limitations of Pivot tables is that they don’t natively return Text values.
This post looks at a method to work around this without the use of VBA.
Formula Forensic 020. Bhavik’s Monthly Workingdays Formula
Bhavik’s has presented us with a neat formula to determine how many working days are in a month.
This functionality has a wide range of uses in accounting, payroll, staff scheduling, accommodation planning & reporting and general scheduling activities.
Today in Formula Forensics we pull Bhavik’s Formula apart and see what is going on inside and the offer some extensions to increase the functionality of his formula.
Formula Forensic No 019. Converting uneven Text Strings to Time
I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this…
Help
Formula Forensics 018. Retrieving the Nth number from a Range which has Gaps.
Over Easter, while we were all busy eating our Easter Eggs, at the Chandoo.org/Forums, Slk213 was worried about how to retrieve the Nth number from a row of data which had gaps in it.
Today in Formula Forensics we will look at how to solve this problem.
Formula Forensics 016. Suzannes DJIA Average
“I was trying to calculate the average DJIA # by month. I had the data by day so tried various combos (none of which worked) (:-”
Learn how to help Suzanne average the DJIA on a particular day and learn about a new Excel Function all in one post.
Formula Forensic No. 015 – Cornelia’s Price Rises
Cornelia wanted to cumulatively increases prices to a lot of products.
See how it was accomplished using an Array Formula to assist.