This is a bit of a tricky subject, in that it depends what you mean by reversing. This particular entry will explore reversing blocks of a String, versus an exact reverse of everything. So, here's an example, how do I get from this: 4189 > 3743 > 2040 > 949 > 195 > 5 To this: 5 > 195 > 949 > 2040 > 3743 > 4189 There's no way to do this natively, in Excel, that I can think of. At least, not without really working your tail off. So, we'll, naturally, roll our

This entry is based on a thread I responded to, here: http://www.mrexcel.com/forum/showthread.php?t=76494 Occasionally the question comes up as to how to derive Monthly Internal Rate of Return (IRR) values. The answer is, well, that would depend what format your data is in, in terms of timing. If your Spreadsheet houses monthly data, IRR() will naturally do this. XIRR() will not, it wil annualize your data. However, see the attached, it shows examples of flipping back and forth (with both), considering

Today's Blog entry comes from a real-World experience I once had, while purchasing a large asset on a deferred payment schedule. The asset's price, like many large assets, wasn't fixed, but negotiable. So, prior to heading into negotiations, our team wanted to understand what various cash flows would look like if we altered the payment schedule to match a targeted Internal Rate of Return (IRR). In order to expedite this process, I used an Excel-native utility known as Goal Seek. In fact

People use Excel for a lot of different things, accounting, engineering, statistical work, etc... Yesterday, a friend asked for help with formatting projected player stats to manage her fantasy draft. I'm attaching the file, there is no VBA. This file isn't extremely refined, as I only spent a few minutes on it. But what it allows you to do is scratch players off the main board, and then quickly scan who remains, by position. And of course you can add Worksheets to compile your draft, add

I received an email from a nice fellow, from a very large Minneapolis-based organization, yesterday, asking how a coworker could learn to use Excel. This is a pretty good question, for mature individuals in the workforce, or potential hobbyists who might think they'll have a need for the software, at some point. Here's my advice, based on my experience. I would not start on your own - the realm of possibilities are too vast and while it's easy enough to say "read the manual"

Okay, let's take Excel 2008 off the table, it ships VBA-less; this is a deal-breaker for me. Note, this is simply my thoughts based on my brief experience, i.e., if you enjoy using Excel on your Mac, more power to you. And this is my take on an out-of-the-box interface, itself, not attempting to set up Jet Connections, etc... I conducted a poll at MrExcel.com, to see if people with PC vs. Mac Excel experience preferred one to the other. The turn-out was underwhelming, but the majority does appear

Macs are the rage, right? Stable, intuitive, splashy looking? Unless you're me - I don't use them - perhaps a subject for another day. But, I do have friends who do, and while I give them an ear-load for doing so, so be it. I recently received a fairly strange email from a friend of mine, using Excel, in an Office 2004 environment: "I have an excel file open with multiple tabs, but all of the tab titles are blank with the exception of the one on the screen. It happened after I copied

If you're a member of Facebook (who isn't? - don't answer that), there's a free draw for a book on Excel 2007 Pivot Tables. And here's where it gets good: it's not written by just anyone, but Debra Dalgleish, undisputed heavyweight champion of Pivot Tables. Here's the offering: http://www.facebook.com/home.php?ref=home#/event.php?eid=109974158504 As I mentioned in my free, online Excel resources blog entry: http://msmvps.com/blogs/nateoliver/archive/2009/05/29/online-excel

Top-5 Primer Worksheet Functions Excel’s a robust and dynamic piece of software offering a variety of capabilities. Today we will discuss the most common use of Excel, an analytical tool with given data sets and 5 must-know, general usage Worksheet Functions to begin to work with Excel. These 5 Worksheet Functions include Sum(), Count(), SumIf(), CountIf() and VLookup(). Sum() Sum() allows one to add values in a variety of manners. The most common use would be to sum a given, contiguous range

Chances are pretty good that if you're reading this blog, you use your computer quite a bit. Today I wanted to mention a nice freeware utility to help you manage your resources, CCleaner: http://www.ccleaner.com What is CCleaner? In their words: "CCleaner is a freeware system optimization, privacy and cleaning tool. It removes unused files from your system - allowing Windows to run faster and freeing up valuable hard disk space. It also cleans traces of your online activities such as your