All articles in 'Excel Howtos' Category
Here is an interesting problem to start your day.
Let’s say you work as DNA sequencing engineer at The Enterprise. And you just unlocked the sequence that is responsible for all male problems. The early onset of baldness. The sequence code is AAAA. And you want to find out how many times this sequence is found in a sample of DNA strings, in the range B6:B19. Essentially you want the above.
So how do you write the formula?Continue »
We know how to use SUMIFS function to answer questions like, “What is the sum of values for ‘A’?” But how would you answer questions like,
- What is the sum of values that are neither “A” nor “B”?
We can still use SUMIFS, but it will get awfully long. So let’s turn our attention to other functions in Excel.Continue »
Last night I got an email from Joshua, one of our readers with the subject – Hard Excel problem. Hard?!?, at this stage of summer, the hard problems seem to be (in no particular order),
- Lack of good quality mangoes to eat
- Intense heat and humidity
- Lack of good quality mangoes to eat
Yes, I like mangoes.
Any how, back to Joshua’s email, So I got curios and read it. He is facing a curious problem.Continue »
Ever wanted to show your workbook to someone and felt that you had less screen real estate? This tip will help you get more out of your workbook.
So how to get 50% more space for your workbooks?
Simple, just follow these steps.Continue »
Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.
Today is Friday the 13th. If you are a raging friggatriskaidekaphobiac, I suggest you to stop reading this post. For the rest of you, I have something fun.
Given a year in cell C3, let’s find out all the months with Friday the 13th. Something like above.Continue »
Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…
Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?
I haven’t, but in this post I will show how you can add it to your worksheets.Continue »
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.Continue »
Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks
Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
Here is an interesting scenario.
Let’s say you are looking at a time, like 9:42 AM and want to know which 15 minute slot it fits into. The answer is 9:30 – 9:45. But how would you get this answer thru Excel formulas?Continue »
One of our readers emailed this question recently,
I like the conditional formatting icons. I am trying to present some business data where going down is good. How do I get a green colored down arrow icon?
Essentially, Ms. CanIGetItInGreen wants this:
Unfortunately, Excel’s conditional formatting icons are not customizable. So we can’t get the green down arrows without some sneak. And sneak we shall.Continue »
Lets look at how to apportion sales according to multiple criteriaContinue »
In case, this is the first time you are hearing about Excel formula wildcards, check out the Using wildcards in Excel VLOOKUP formula tutorial.
So you know about wild cards like * ?, now how would you tell VLOOKUP to ignore them?
Say, you are genuinely interested in looking the value “* Payroll” in a lookup table. What then?
This is exactly the problem faced by Peter in our forum post VLOOKUP and cells with “*” NOT to be interpreted as wildcardContinue »