Find Minif, Maxif
Hi
Many times you got stuck with a thought of why Minif and Maxif is not provided along with Sumif, Countif ? And yes, even I do think on the same lines. Today I am going to demonstrate you can easily achieve the same though not provided by excel, but I still expect Microsoft to add this support natively.
Text Split with Excel Formula – Part III
Hi Friends
After many appreciations on Part I and Part II, there were few queries which I am trying to address in this part. The purpose of this series is to make everyone aware about text functions and advanced use of them.
Previously we seen the use of left, right & find formulas. In this part we will additionally see use of substitute.
Excel Function – Convert
Friends, have you come across a situation when you want to calculate inches from centimeters or hours from days in excel, very simple we do the mathematical calculation easy right? but there is an easier way provided by excel CONVERT function
Shifted to
Hi Friends,
The time has come to take more control on this blog and add few customizations which would not have been possible with free account of wordpress.com.
So we have decided to transfer this blog to our domain resoluter.com
click here to visit
I hope you will continue the support to new site. All posts and pages are already moved to new site.
Update – Sep 5, 2011 9:20 AM
During migration we have moved all below pages to our new site, use links below for easy navigation
We will also moving all other post to the new site over a period of time
Text Split with Excel Formula – Example
In one of the comments it has been asked as query about splitting some text from a string. In this post I am answering the query plus further extending it so that we can cover maximum use of Text Formulas Left, Right and Mid.
The query -
How to get Ch. No. 123456 from entire string like
Case 1 – ‘Ch.No. 123456 being the amt paid to party against bill no.256 dt. 12.07.2011′ or
Case 2 – ‘Mr. X given Ch.No. 123456 being the amt paid to party against bill no.256 dt. 12.07.2011′.
Recent Comments