The short answer is no, there is no standard function in Excel to do
that.......the long answer is YES, if you really want to do that, you can get
there using some of Chip Pearson's clever techniques..........see here
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.