Excel Zone Expert Discussion, Number 36

This thread is for general discussion about all things related to the Excel zone and its experts. Both regular contributors and newcomers are always welcome. Topics might include:

    Asking for assistance with specific questions.

    Issues, announcements, and discoveries related to this zone.

    Discussing Experts Exchange features and functions that are of specific interest to this zone's experts and do not require moderator participation.

    Recognition of new experts, amazing posts, and accomplishments related to this zone.

    Getting to know your fellow Excel experts.

    Planning meets and greets with other Excel experts when traveling.

And, occasionally, a little humor and other completely unrelated topics that are of interest to the Excel community.

Drivel posts such as "First Post" or "Subscribing" will be deleted. There is a "Monitor" link on this page. Click it. It does magical things.

This thread must not be used for any of the following:

    Presenting any specific member in a negative light.

    Suggesting that any specific member needs to change their behavior.

    Suggesting that others blacklist any OP for any reason.

Whenever an issue arises with a specific question, avoid engaging with others in that question and use the "Request Attention" function to request moderator assistance. More general issues and concerns should be taken up privately with the site moderators, all of whom are listed here (select "Community Volunteers"). You can contact admins, moderators, zone advisors, and page editors using their member name: membername@experts-exchange.com. This will not work for cleanup volunteers.

If you have a question about how this site functions or a problem using this site, please post a separate question in one of the community support zones. Doing so helps keep this thread focused on Excel related topics and gives other members with similar problems a better opportunity of finding the solution assuming there is one and it's posted to your question.

Previous discussion thread: http:/Q_28228300.html
Next discussion thread: http:/Q_28428578.html

Zone Advisors
When this thread reaches a page size of about 100K (about 300 comments):

    Create a new "Expert Discussion" thread using this content as a template, incrementing the number in the title, and setting the "Previous Expert Discussion" link to this thread.

    Edit the new thread and set the points to zero.

    Edit this question and set the "Next Expert Discussion" to link to the new thread.

    Make a final post in this thread with a link to the new thread "Next Expert Discussion: http:Q_xxxxxxxxx.html" and accept that post as the solution.
LVL 81
byundtMechanical EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
Am I the only one who cannot see the subscribe to question option?
0
rspahitzCommented:
I'm not sure I see the subscribe either, but always forget where to look anyway.

Can someone tell me the inherent differences between Excel 2013 and Excel Online (or 365 or whatever they call it)?  Is it just where it's hosted (local versus cloud) or are there other fundamental diffs like how macros work?
0
IrogSintaCommented:
Can someone tell me the inherent differences between Excel 2013 and Excel Online (or 365
Well one difference is that Office 365 is a subscription service where you pay annually for its use rather than paying once for the product.  365 gives you the choice of downloading the whole office suite on up to 5 computers you use.  The downloaded applications have all same features you're used to; however 365 also offers WebApp versions of some of the programs (i.e. Word, Excel, Powerpoint and OneNote) that have a limited set of features.  This way you can still work on your document or spreadsheet even on another computer that doesn't have Office.  You would of course need to keep your documents stored in SkyDrive which is also part of Office 365.

Ron
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

byundtMechanical EngineerAuthor Commented:
The web version of Excel (which I have never used) has limited features, but Microsoft is adding to it on a regular basis (multiple times per year). Data validation dropdowns were a recent addition, for example. It doesn't have VBA.
0
Zack BarresseCEOCommented:
Ron is mostly correct, but there can be some specific differences in regards to specific subscriptions. It is true Office 365 is a subscription-based service, which may or may not include the Office applications (in all their flavors, which aren't all equivalent).

For most subscriptions you can download/install on up to 5 machines. It's a web installer (click to run) by default. They won't give you an MSI, even if you ask nicely. One fundamental difference is with the ProPlus version, which gives you one single install, that's all.

And there is a difference between ProPlus and Professional Plus. While ProPlus is only available by way of O365 subscription, Professional Plus is available by volume license only. You can also buy standalone apps, and these are not the same necessarily as the apps you get from the subscription model. One major difference is with Excel, where if you get an O365 subscription (not the ProPlus version) you will not get PowerPivot. And I should mention there is no way for you to get it. Period.

In all of the subscription models the installs are on a per-user basis. This means they aren't really tracked by machine install, but by user installs.

The web apps which come with an O365 solution are the same apps available to everyone for free (i.e. with a Hotmail account), but allows you to install it on a company intranet. A benefit of that would be not needing internet connectivity, local (server) data storage, integration with internal SharePoint sites, etc. As Brad mentioned they are getting revisions all the time, sometimes as much as once a month, and at least once a quarter. The other benefit with the web apps is you don't need to worry about sending/applying updates to your users. If you're a system/network administrator you know how much of a pain it can be in applying updates. With web apps they're applied to the server and everyone uses the latest version all the time.

Technically SkyDrive isn't a part of Office 365, they are two very different animals. SkyDrive has been around for a number of years now. (Of course the name may be changing due to a lawsuit Microsoft lost in the UK for that copyrighted name, so who knows what it'll become in the future.) You can store/connect to files there from an O365 account, but you can from any desktop install of Office anyway. Same way you can with a SharePoint site as well.

If ever switching subscriptions, you can migrate across a family of plans, but not to a different family altogether. For example, if you have a Home subscription, you can switch to a Home Premium, but not a Small Business. To do that you'd have to drop the Home plan and subscribe (new) to Small Business. This usually isn't much of a problem except that you have to choose a domain name when creating your subscription. The default domain will be YourCustomDomainName.onmicrosoft.com. As you can tell, if you have a long domain name, the entirety of it will be exhausting to type repeatedly. If you have your own domain it's fairly easy to tie in the hosted Exchange services. Where this will become tricky is if you use the hosted Exchange (not routing through your own domain) or use the hosted SharePoint site. This is because you can't transfer domains across to a different plan type (e.g. Home, Small Business, etc).

Zack
0
IrogSintaCommented:
Technically SkyDrive isn't a part of Office 365
I think it isn't part of the Office Suite of products; however it is very much integrated into Office 365.  In fact, in order to use the WebApp versions of the programs you have to go to the SkyDrive section after you log in.
WebAppsRon
0
Zack BarresseCEOCommented:
Integrated yes, as with all of Office, and heavily at that (on purpose). But you don't have to use SkyDrive to have an O365 subscription.

Zack
0
Saqib Husain, SyedEngineerCommented:
Netminder,

I cannot see what you are trying to show. It used to be there but i cannot see it now. Sometimes it used to go to the bottom of the screen but now it is not there either.

Screenshot
0
rspahitzCommented:
Thanks all for the O365 update.  Sounds like the web version is quite different from the local versions (all of which seem similar but may be slightly different.)
I'll have to check and see if the look-and-feel is about the same as 2010 too...
0
Zack BarresseCEOCommented:
Accounts are free (e.g. Hotmail, Live.com). The Excel team posts updates on the web app (not sure about the other apps) to their blog when they have major updates (i.e. data validation). http://blogs.office.com/b/microsoft-excel/ In fact their latest post (by Dan Battigan) is on the Excel web app (http://blogs.office.com/b/microsoft-excel/archive/2013/09/11/excel-web-what-are-we-thinking.aspx). You can even share your opinion in that post, look for the survey link near the bottom. :)

Zack
0
cyberkiwiCommented:
Google Hummingbird update - no relief in "site" for this site

"vba amazon hmac" - page 1 #3
"disable outlook prompt mapi" - no useful ee result, even with site:experts-exchange.com
"node.js sql server example" - no useful ee result, even with site filter
"hexagonal excel tiles" - ee not on first few pages
"connect outlook 2010 to exchange 2003" - not in first 5 pages
"excel vlookup on two columns" - can't see ee
0
[ fanpages ]IT Services ConsultantCommented:
cyberkiwi: I used "excel vlookup on two columns experts-exchange" as Google search criteria.

The second & third entries in the results where links to this site (actually articles written by Patrick)...

[ https://www.google.co.uk/search?hl=en&tbo=d&output=search&sclient=psy-ab&q=excel%20vlookup%20on%20two%20columns&=&=&oq=&gs_l=&pbx=1#hl=en&q=excel+vlookup+on+two+columns+experts-exchange&safe=off ]

Second:
[ http://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDwQFjAB&url=http%3A%2F%2Fwww.experts-exchange.com%2FSoftware%2FOffice_Productivity%2FOffice_Suites%2FMS_Office%2FExcel%2FA_10590-Finding-the-Nth-Lookup-Value-in-an-Excel-List.html&ei=b7ZHUtqAOI-qhQenloBA&usg=AFQjCNGw3RmosUrx8mQWdHYVQZTxK5sueg&sig2=iZGwXeCXDeRaJgi-PftxpA&bvm=bv.53217764,d.ZG4&cad=rja ]

Third:
[ http://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&ved=0CEYQFjAC&url=http%3A%2F%2Fwww.experts-exchange.com%2FSoftware%2FOffice_Productivity%2FOffice_Suites%2FMS_Office%2FExcel%2FA_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html&ei=b7ZHUtqAOI-qhQenloBA&usg=AFQjCNExqSOjdGka1r50zucZW8faAyTuiA&sig2=I3b3BHxo8hmgLfeFG86NTw&bvm=bv.53217764,d.ZG4 ]


I didn't try the other examples you listed.

However, if the site developer's changed the articles so that a related list of previous questions (perhaps using keywords, or even questions, suggested by the article author, rather than just additional articles by the same author) could be displayed either at the top, the bottom, or both the top & bottom of the articles, then anybody visiting from Google may then look elsewhere on the site.


PS. Grrr...

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28249890.html#a39530763 ]
0
[ fanpages ]IT Services ConsultantCommented:
I might add this to my Profile page:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Powerpoint/Q_28252555.html#a39530816 ]

I'm now  beginning to think that there are serious ego or psychological issues involved and I will have to escalate this further.
0
DaveCommented:
Maybe that belongs to "fab pages" ? :)
0
[ fanpages ]IT Services ConsultantCommented:
:) I just didn't want to respond to that in case it looked like I was being egotistical or something.
0
[ fanpages ]IT Services ConsultantCommented:
Actually, looking at the description of the LinkedIn group "Excel and VBA Users"...

"This is a group for Excel and VBA users who have issues or who would like to share ideas."

I think I fit in the first category.
0
byundtMechanical EngineerAuthor Commented:
fanpages,
Thanks for flagging the PowerPoint thread. I have weighed in, both in the original incarnation and its successor, and trust that Moderator review will back both of us up 100%.

Brad
0
[ fanpages ]IT Services ConsultantCommented:
Thanks Brad.

I was grateful for your input, especially backing the comments by the PowerPoint MVPs, & the reason(s) for not deleting a question once a solution has been provided.

I will not comment further in either thread, unless you think either warrants my additional input.  I fear we may have lost a paying member in the whole process though.  That was obviously not my intention.  Sorry :(

This aside, the fact PowerPoint does not support Auto_Open() or have a Presentation_Open() or SlideShow_Start() [or similarly-worded] event is a very odd approach from Microsoft, but at least I learned how to tackle this in the couple of hours of development I took in the first thread.

If anybody wishes to know how I achieved the execution of code (& the initiali[s|z]ation of a class object) in PowerPoint when the Presentation's SlideShow was started, & you cannot deduce this in the first question (link below), please ask & I will explain what I did (here in this thread).

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28249890.html ]

Thanks again.
0
[ fanpages ]IT Services ConsultantCommented:
:)

I prefer a quote from Winston Churchill:

"Never engage in a battle of wits with an unarmed man".
0
SteveCommented:
For the FP PowerPoint question...
    I think that FP is completely in the right here.
    When the asker got exactly what they asked for (but not what they wanted)
    They should have accepted the solution from FP and then raised a new question to bridge the remaining gap.

FP gave an excellent answer and a very kind response when the asker changed the goalposts.
The asker seems to me to be the rude one, but he pays for that right... right?

Maybe Derren Brown or Uri Geller would do better?

ATB
Steve.
0
byundtMechanical EngineerAuthor Commented:
The Asker seems to me to be the rude one, but he pays for that right... right?
Actually, the Asker pays for access to the forum--to be able to post a question and to search PAQ and Articles.

If an Asker thinks he has paid for the right to be rude, then the thread needs to be flagged for attention by Moderators or Topic Advisors. We are blessed with many of both in this thread, and the Request Attention link will also get the right kind of action.
0
SteveCommented:
Indeed Brad, but this one seems to think that he pays for the right to treat the experts like some kind of subordinate.
He may need educating in more than Powerpoint, manners for one.
0
byundtMechanical EngineerAuthor Commented:
He may need educating
Is why Request Attention is your friend. That particular Asker is in a frame of mind that allows him to interpret a very mild response by me as being hostile.

I'm glad to see Echo_S and JSRWilson backing fanpages up regarding the difficulty of the task. With any luck, the Asker may even agree after a good night's sleep.
0
[ fanpages ]IT Services ConsultantCommented:
Oh dear.

I have just submitted a further report, as an e-mail address of an "Expert" has been posted here:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Powerpoint/Q_28252555.html#a39531610 ]

The continuing discussion seems to be about the exchange of a fee to provide further services.
0
[ fanpages ]IT Services ConsultantCommented:
Thanks again Brad.

(Thank you for your comments earlier today as well, Steve)
0
mvidasCommented:
Hi all,

Just a quick hello as I'm passing through, had the opportunity (and time) today to stop by and figured I'd try my hand at the old game. Hope you're all doing well :)

Matt
0
Zack BarresseCEOCommented:
Matt! Hope all is well. And hope them two little hellians are treating you ok!!

Zack
0
DaveCommented:
How not to use a Q&A website when you're on the wrong side of legal.
0
[ fanpages ]IT Services ConsultantCommented:
The question has not been removed (following the various articles now published with links to it), because there is no such thing as bad publicity.
0
rspahitzCommented:
Hmmm...I've always been leery when I see questions like: how do I create an app that nobody detects that lets me erase a file...(i.e. how do I hide the virus that I'm creating)
0
[ fanpages ]IT Services ConsultantCommented:
Why would it be considered an "illegal" question?

"The Onion Router" is not illegal to use.  The activities somebody may undertake utilising the software is another point entirely.

Can you confidently say that every question you have ever answered here has been solely for legal activities?
0
byundtMechanical EngineerAuthor Commented:
If you were ever irked by the "internet only" nature of Help files for Excel 2013 VBA, relief is in sight. You can now download offline CHM versions of the VBA developer reference for each of the Office 2013 apps at http://www.microsoft.com/en-us/download/details.aspx?id=40326 

It could come in handy when you are stuck in an airplane without internet access. I use Excel 2003 Help in such situations right now. Alas, these offline files won't be linked to the F1 context sensitive help button.
0
[ fanpages ]IT Services ConsultantCommented:
Thanks for the useful link, Brad.

...

Can you confidently say that every question you have ever answered here has been solely for legal activities?

I don't know how the possible illegality of the questions I've answered has any relevance at all. I kind of doubt that any of the solutions I've posted have been used illegally (at least by the people asking them), but I suppose most of them could have (for example, answering a question about how to do something in CSS could be used on a website that engages in illegal activities).

I see COBOLdinosaur, Topic Advisor was questioning legality earlier this week:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28259224.html#a39550578 ]
0
byundtMechanical EngineerAuthor Commented:
fanpages,
I've added to the stream of purple (hidden) comments in http:/Q_28259224.html   I see gray where COBOLdinosaur saw only black or white. And it is definitely not a case of legality, but rather of breach of the Terms of Use.

Thanks for bringing the issue to my attention.

Brad
0
[ fanpages ]IT Services ConsultantCommented:
Hi Brad,

You're welcome.

However, since resigning as a Community Volunteer I only see "black & white" (not purple/hidden) comments too.

BFN,

fp.
0
byundtMechanical EngineerAuthor Commented:
In the Wow Department:

fanpages shows how to pass a set of non-contiguous ranges to COUNTIF as its first parameter in http:/Q_28258075.html#a39546115 That's something I would have sworn was impossible had I not seen it done.

The trick is to use INDIRECT to create the union of ranges in veiled fashion so COUNTIF doesn't balk. When you do that, the formula doesn't even need to be array-entered.
0
[ fanpages ]IT Services ConsultantCommented:
:)

I think barry' needs an "approves" image like this:

Chuck Houdini...
0
[ fanpages ]IT Services ConsultantCommented:
A "Topic Advisor" may wish to add a comment here:

[ http://www.experts-exchange.com/Q_28264440.html#a39565192 ]
0
byundtMechanical EngineerAuthor Commented:
fanpages,
Thanks for the heads up!

I've deleted the Comment in that thread with blind links, and posted an Admin Comment on the issue.

Brad
0
[ fanpages ]IT Services ConsultantCommented:
Thanks Brad.
0
[ fanpages ]IT Services ConsultantCommented:
It seems we are lacking in SAP "Experts"; time for a recruitment drive! :)

In the meantime, just for fun...

[ http://www.exceltrick.com/wp-content/uploads/2013/05/History-of-Excel-From-1978-2013.png ]

[ http://www.exceltrick.com/others/history-of-excel/ ]
0
aikimarkCommented:
Patrick Matthews posted a link to an Excel (what is now VBA) language development story by Joel Spolsky.  It is an interesting view of Microsoft's earlier days and how Bill Gates shaped the company.  The F-counter at the meeting is precious.
http://www.joelonsoftware.com/items/2006/06/16.html
0
[ fanpages ]IT Services ConsultantCommented:
I read that article earlier this week when somebody sent a link to me.  I didn't share it as I thought, being from June 2006, that is was old news (to everybody except me).

Another "blast from the past", Brad Templeton's article on how he "invented" the dot in "dot com":

[ http://www.templetons.com/brad/dot.html ]
0
byundtMechanical EngineerAuthor Commented:
Thanks for that link, fanpages. It was a bit of interesting trivia that I was completely unaware of until reading.

Starting on a Linked-In post, I eventually got linked to a Cyrille Vincey webpage asserting that Excel is the best tool for data visualization. That's a pretty inflammatory statement, so I read and was amazed. In the examples shown, he starts with basic Excel charts and strips away almost everything until he ends up with a pretty compelling graphic.

Brad
0
Zack BarresseCEOCommented:
Brad, a lot of the new Excel (2013) templates are the same way. But those were designed by an actual design firm, although the implementation of them only took a few hours. It definitely helps to see some 'good' working examples first. In the words I love by Chandoo, don't put lipstick on a pig (e.g. less is generally more). lol

Zack
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Anyone seriously working with data visualisation and charts should have Stephen Few's books on their desks. This is where you really start to see what matters in charts.

Show Me the Numbers
Now You See It
Information Dashboard Design

The above may not be the latest versions. Amazon is your friend.

... and read his blog http://perceptualedge.com/
0
gowflowCommented:
Hello,

Anyone have an idea how to programmatically thru VBA get the same action as
ALT F (get the file menu to show and stay there ?)

on my part I added a test on the worksheet_selectionchange event and added these 2 lines

ActiveSheet.Activate
SendKeys "%F"

and what it does it show you for a split second the file menu which disappear afterward. it seems that when the event finishes it select or go focus on the cell and the menu disappear again. I was not able to get it to show still.

Any idea ?

This is the first time I post in here if this is misplaced or not appropriate please do not hesitate to let me know.

Thank you, Regards
gowflow
0
[ fanpages ]IT Services ConsultantCommented:
Hi gowflow,

This is the first time I post in here if this is misplaced or not appropriate please do not hesitate to let me know

Although you are very welcome to keep to the topic as described at the top of this thread, yes, unfortunately, it is not really the most appropriate place to ask such a question.

Is there a reason why you didn't wish to create a separate question thread (as you have done many times before)?

I am sure if you do create a new question, then the regular contributors here will add comments as appropriate.

BFN,

fp.
0
gowflowCommented:
Thank you for your comment which is well noted.
gowflow
0
byundtMechanical EngineerAuthor Commented:
I invited gowflow to participate in this thread. He's been answering too many Excel questions not to be here as well.

Brad
0
Rory ArchibaldCommented:
Honestly I don't know why the OP doesn't just use a custom tab. As I mentioned in the thread, I don't think there is a programmatic method, unless perhaps the Accessibility objects would work.
0
gowflowCommented:
rorya your correct maybe good if you throw an example in the question raised (I would b curious to know how as well). Actually it is not clear what he intends to do after the ALT F ?
0
Rory ArchibaldCommented:
Sorry - an example of what? (I know he already knows how to do custom tabs or I would have given one)
0
gowflowCommented:
got it thought it was a vba example.
0
rspahitzCommented:
Anyone want to assist in adding VBA automation code to open Photoshop with a specific file, submit updates and save it through Excel?

http://www.experts-exchange.com/Microsoft/Applications/Q_28274916.html#a39595077
0
[ fanpages ]IT Services ConsultantCommented:
Just for background information, in case Faustulus carries the discussion into this thread...

This question was listed a few hours ago:
[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28278064.html ]

It is not a difficult task, but far from trivial in terms of input (read: time) required to completely address all the requirements.

I suspect the continued discussion (further to Brad's input to the thread) is far from what the question asker wishes to read, but it does raise the 'age old' issue of quantity versus quality in code submitted as proposals to answer questions.
0
[ fanpages ]IT Services ConsultantCommented:
^
VBA doesn't cause the problem.
AutoIT causes the problem  :(
0
[ fanpages ]IT Services ConsultantCommented:
Q: When is an accepted solution, not an accepted solution?

A: When it is this one:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28281378.html#a39612408 ]

Weird issue in any respect.
0
byundtMechanical EngineerAuthor Commented:
About the most left-handed compliment I've received:
I was preparing a condescending reply to explain how you fail to understand how events are processed in Excel when I took the time to understand your code. Brilliant solution. It works as described.
0
[ fanpages ]IT Services ConsultantCommented:
About the most left-handed compliment I've received...

I was preparing a condescending reply to explain the difference between right, left, & back-handed compliments, but decided just to say that right & left hands are complements anyway.
0
zorvek (Kevin Jones)ConsultantCommented:
Nigel, I've missed you sooooo much!
0
byundtMechanical EngineerAuthor Commented:
Excel spreadsheet botched in ad for new Surface tablet. The sum isn't right--not exactly a ringing endorsement for our favorite MS product.

The advertising agency also Photoshopped the colors and separating lines in the exploded pie chart. I guess Excel 2013 wasn't vibrant enough.
0
Steven HarrisPresidentCommented:
The pie chart actually looks identical to QA Pie Charts; however the orange in the ad is slightly more of a red hue.

The SUM is just embarrassing.
0
zorvek (Kevin Jones)ConsultantCommented:
Guys, don't go too far down this rabbit hole. The graphics were probably created by an intern using a graphics program and not Excel. It's a common practice with which we technologists are not familiar.
0
Zack BarresseCEOCommented:
I guess Excel 2013 wasn't vibrant enough.
It never is with Microsoft designers. They always, ALWAYS f*ck with things.

Zack
0
[ fanpages ]IT Services ConsultantCommented:
Zack: I think you may appreciate this...

[ http://excelmatters.com/?p=149 ]

:)
0
[ fanpages ]IT Services ConsultantCommented:
(PS. Rory... was that plug subtle enough?  I'm guessing nobody noticed)
0
Zack BarresseCEOCommented:
Heh, I saw that one. :)

I've had a lot of work with the Office Content team, and most often if they "run with it" or don't seek expert consultation, you'll end up with FUBAR's like that [ad] lol. But, to be fair, the designers are generally outside contractors, much like their (content) experts.

Zack
0
Rory ArchibaldCommented:
Nigel, thanks. Cheque is in the post. ;)
0
[ fanpages ]IT Services ConsultantCommented:
:) I don't think you know my address... However, you may wish to consider a masking service for your own courtesy of the whois record for your domain name (if you don't want nutters contacting you after quoting pages of your web site in other threads).

Nutters in this one are allowed, of course! ;)
0
byundtMechanical EngineerAuthor Commented:
PS. Rory... was that plug subtle enough?
It went right over my head the first time. Second and third time, too. It was only the tidbit about whois that enabled me to find Rory's Excel blog.
0
barry houdiniCommented:
I don't know what's going on here

Asker says that he gets different results in Excel 2003 and Excel 2010 with a formula using LINEST function. I don't have access to Excel 2003 but I tried in Excel 2007 and pulled out just the LINEST part and array entered in a 5 row x 3 column grid (A1:C5)

If you open in Excel 2007 then A1 and A2 are zero but in Excel 2010 B1 and B2 are zero

Why the difference?

Please feel free to jump in on the question, I'm off to watch the cricket......

regards, barry
Book1.xlsx
0
gowflowCommented:
What does it mean when a question posted is Private ?
gowflow
0
Steven HarrisPresidentCommented:
Private Questions are kept out of search engine results.  They are still visible to logged in members.
0
gowflowCommented:
thank you thinkspacesolutions.
0
Steven HarrisPresidentCommented:
No worries.  I had the same question at one point until I ran across a post from Netminder.
0
byundtMechanical EngineerAuthor Commented:
If you see new Expert samrad1 posting in the threads, he works for Microsoft on the Excel team and is a heck of a nice guy.

He also takes the time to make his Excel workbooks look less like cells on a grid and more like an appealing handout or report. Take a look at some of them (QPB, Kamping, and Search4love) on his SkyDrive http://sdrv.ms/Y4LAhp

Please give him a welcome!
0
byundtMechanical EngineerAuthor Commented:
Justincut has recently been posting a series of questions trying to get around the VLOOKUP limitation of 255 characters for the lookup value. VLOOKUP flat out won't do it, even with a wildcard.

zalazar, who has been a member since August 2003 but hasn't ever answered a question in the Excel TA, shows a cute workaround using INDEX and MATCH in http:/Q_28302392.html#a39673165  Instead of looking for a value with more than 255 characters, zalazar used MATCH to search for TRUE against an array of Boolean values returned by INDEX. The resulting formula doesn't even need to be array-entered.
=INDEX(ResultColumn, MATCH(TRUE, INDEX(MatchColumn=lookup value, 0), 0))

Or you can array-enter it without the second INDEX:
=INDEX(ResultColumn, MATCH(TRUE, MatchColumn=lookup value, 0))

Nicely done, zalazar!


barryhoudini posted a similar formula in StackOverflow about a year ago, but I hadn't noticed it before.
0
samrad1Commented:
Hey thanks byundt! You're not so bad yourself :-)  Thanks for showing me the experts exchange when visiting MS, great meeting everyone here!!
0
NBVCCommented:
Not to take away from zalazar's kudos... but I suggested the very same thing days earlier to Justincut...

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28293249.html

and because his results were initially to be numeric, I also suggested a SUMPRODUCT version that would also take care of the 255 char limit.


=SUMPRODUCT(--(Journals!$B$1:$B$1000=B305),Journals!$O$1:$O$1000)

Justincut seemed to be determined to use the UDF version, even in following threads...

Btw, welcome samrad1 :)
0
byundtMechanical EngineerAuthor Commented:
NB_VC,
I should have noticed the MATCH with TRUE workaround when you did it, since I edited the thread in question. My apologies.

It's a great workaround for the 255 character limit no matter who posted it first.

Brad
0
mvidasCommented:
I found a situation today that I can't explain, where a for loop is working incorrectly.
Question: http:Q_28299598.html
Sample file: http://filedb.experts-exchange.com/incoming/2013/11_w48/690102/Integra0.xls

Briefly, I have a "For Each CLL in range.cells" that looks for a cell containing "Yes". If it finds Yes, it inserts a row above CLL, which obviously changes the CLL address (Q17 becomes Q18, so the next iteration looks at Q19). Strangely, on the second time it finds "Yes", Q22 becomes Q23, but the next iteration looks at Q23 again.
Even weirder, if the second iteration is manually fixed during runtime, it works correctly for the third find of "Yes".

I'm going to attach a text file with the macro in it (minus a pagesetup portion that lengthens the runtime). I put a Stop right above the loop in question. Am I just missing something?
samplecode.txt
0
Rory ArchibaldCommented:
I think that because your first Yes value is also the first cell in the range, the range you are looping through also shifts down. The internal counter knows it has processed the first cell (which is now Q18) so it moves on to the second (Q19). On subsequent passes, the range expands rather than moving, so the cells get processed repeatedly. If you change the value of Top to 16 before the loop starts, you should see the same behaviour for all Yes cells.
0
mvidasCommented:
I understand that then. I guess I always interpreted 'For Each in range.cells' to look at each cell in the initial range instead of iterating through cells(1) cells(2) cells(3) etc. Strange that I've never encountered this before, but it happens. Thanks!
0
Rory ArchibaldCommented:
It basically holds a reference to that range, so if you move/adjust the range, the loop alters accordingly. Simple example:

Sub foo()
   Dim rCell As Range
   For Each rCell In Range("Q1:Q2").Cells
      Debug.Print rCell.Address
      Range("Q1:Q2").Cut Range("S3")
   Next rCell
End Sub

Open in new window

0
mvidasCommented:
Thanks! I haven't been in an airport in years -- easier to avoid the bad luck that way ;)
0
Zack BarresseCEOCommented:
Sam!! Good to see you buddy. :)

Zack
0
zorvek (Kevin Jones)ConsultantCommented:
How do you see him? I can't see anyone. Maybe I need new glasses.
0
Zack BarresseCEOCommented:
I see him with my eyes, err, I mean "special powers". You are getting old.

Zack
0
[ fanpages ]IT Services ConsultantCommented:
Re: "Kudos and Milestones, Dec 4th"

Milestones:

matthewspatrick has earned 2,000,000 points in each of five topic areas. Only two other EE members have accomplished that.

Congratulations Patrick :)
0
nutschCommented:
Il est fort, le bougre !

Congratulations Patrick!
0
mvidasCommented:
Can someone who is less rusty than I am in ADODB/access connections look here and possible help out? http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28299335.html 
I'm not sure what else I can add, and I don't want to leave him hanging if possible

Thanks
0
[ fanpages ]IT Services ConsultantCommented:
[ http://blog.experts-exchange.com/ee-blog/refer-friends-experts-exchange-get-cash-rewards/ ]

...4. When your friend makes their first payment or reaches Qualified Expert status (10,000 points), we’ll send your reward via PayPal within 90 days to the active email address on your account. If you want to make sure you have the same email address on your PayPal and Experts Exchange accounts, click here to learn how to change your email address.

Also:

...Monetary payments are sent to your email address via PayPal in US dollars within 90 days. In order to receive monetary payments you are required to have an active and valid PayPal account with the same email address as the active email address on your Experts Exchange account. PayPal may offer currency conversion for a fee, see PayPal terms & fees. Please review the full Referral Program Policy before participating in the referral program.


Why is there not the option to have a different Experts-Exchange.com log-in e-mail address & PayPal account e-mail address?  Why do they have to be the same?

I have two different e-mail addresses for security reasons.

Am I alone in this approach?
0
zorvek (Kevin Jones)ConsultantCommented:
You're not alone. It's a completely unnecessary requirement. I can think of two possibilities. Engineering said it would cost to much to add the requisite field to allow a separate email address for Paypal - a database change, changes to one of the membership edit pages, and an email telling the rewarded member that they have not yet entered it. Or someone figured that this is more secure which, of course, is ridiculous since there is no risk in having just the Paypal email address. But, then again, I've seen similar ridiculous risk aversion tactics in the past like limiting the file extensions that can be uploaded.

Another amusing observation is the 90 day delay. When money is going from us to them it flows freely with seconds of the due date. The reverse always seems to take a wee bit longer. It's a money game.
0
[ fanpages ]IT Services ConsultantCommented:
[ http://blog.experts-exchange.com/ee-blog/valuable-experts-gamma-class/ ]

"Introducing the Most Valuable Experts Gamma Class"
Posted on December 19, 2013 by EE Staff

Most Valuable Expert: Brad Yundt
 •12,291,047 points overall
 •#3 expert overall in Microsoft Excel
 •14 certifications overall
 •Specialty: Microsoft Excel MVP
 
Like many folks, Brad Yundt (byundt) came to Experts Exchange while searching the web for an answer to a technology question. Seeing the value in joining the community, but not having the resources to pay for the monthly membership fee, Brad decided to participate as an expert for free membership. Ten years later, he is a topic area advisor and in the top 25 experts of all time on the site. He also has a reputation for providing quality answers–particularly in the Microsoft Excel topic area.
 
“I started tackling threads that were ignored because the askers wanted more work than the other experts were willing to provide,” he says.
 
Community members bvanscoy678 is one such example. After Brad helped him analyze the response times of the fire department he worked for, bvanscoy678 had a tool that he was able to use to justify opening up new fire stations in a time of fiscal austerity.
 
According to Brad: ”My favorite questions are where my efforts have truly made a difference in someone’s life.”

Congratulations Brad! :)
0
[ fanpages ]IT Services ConsultantCommented:
Also congratulations to...

Most Valuable Expert: Barry Houdini
 •4,942,447 expert points overall
 •6 certifications overall
 •Specialty: Microsoft Excel
 
Barry Houdini’s (barryhoudini) tips for success at Experts Exchange are simple: “Be nice. Be right. Be concise.” If his posts in the Microsoft Excel topic area are any indication, he’s taking his own advice.
 
“I’m active in several Excel forums, and they all have their different characteristics,” Barry says. “At Experts Exchange, I think there’s some healthy, friendly competition amongst the Excel experts; and the top experts really are at the top.”
 
When he’s not “excelling,” as he calls it, Barry works for a large transport operator company in London, tends to his dahlias, shoots skeets…and telling tall tales. His name, in case you haven’t already guessed, is a pseudonym. But, as he explains: “I’ve been using (the pseudonym) for so long that even my wife calls me Barry.”
 
It’s up to you to figure out if that’s another one of his tall tales.
0
rspahitzCommented:
Way to go Brad and Barry!  You guys are awesome!
0
SteveCommented:
Grants indeed and we'll deserved... Way to go guys.
ATB
Steve.
0
byundtMechanical EngineerAuthor Commented:
There's a thread discussing the central issues facing Experts Exchange at http:/Q_28325346.html with CEO Brian Clausen contributing. If you feel vested in the EE Community, you ought to consider monitoring the discussion and contributing as you see helpful.
0
DaveCommented:
Interesting question at another forum as to whether the arguments in an Excel function (or UDF) can be accessed programmatically.

Happy New Year all :)

Dave
0
byundtMechanical EngineerAuthor Commented:
Congratulations to teylyn, who was renewed as Excel MVP for another year!
0
byundtMechanical EngineerAuthor Commented:
Congratulations also to brettdj, who was also renewed as Excel MVP for another year!
0
Zack BarresseCEOCommented:
Congrats Dave and Ingeborg! Maybe Dave can pull away from his important job and attend another Summit one of these years. :)

Zack
0
byundtMechanical EngineerAuthor Commented:
Didn't you just get reawarded too, Zack? Congratulations!

Brad
0
Zack BarresseCEOCommented:
Yes, I did. Thank you!

Zack
0
DaveCommented:
Thx guys and congrats to the others who have been re-awardees,  although I'm actually on the July cycle.

Zack, if I'm fortunate to get back in again I would like to get to another summit down the track, but the current timings are tricky for me from a work perspective.

Will Rory ever turn up?
0
Zack BarresseCEOCommented:
I hope so! There are so many I wish would make it. I really do understand though, I'm just being selfish. :)

Zack
0
Rory ArchibaldCommented:
If it remains in November, the answer sadly is no. There is no chance of me getting time off then as it's our manic time at work. (unless of course I change jobs!)

Congrats to all. :)
0
aikimarkCommented:
I was helping a college buddy automate one of his workbooks, introducing him to VBA coding.  He's a bright math guy, doing actuarial work, so this wasn't too painful for either of us.  He posed the following question:
Can you recommend a book, website or other source that's a good reference for VBA
commands?

I certainly recommended that he get his company to pay for an EE membership and look around for user groups in his city (or mine).  I thought I'd ask the EE Excel experts what they would recommend.  What say you?
0
byundtMechanical EngineerAuthor Commented:
Far too many Excel VBA books echo the Help for each of the keywords. Even though they look comprehensive and useful in the bookstore, they may not add that much value beyond what Microsoft has already given you.

I recommend John Walkenbach's Excel 2013 Power Programming with VBA for people who want to learn VBA. There's enough meat in it to justify keeping it on your shelf, yet it is approachable by people who are just beginning. Though I mentioned the 2013 version, it is updated for each new version of Excel and the content hasn't changed that much since 2007.

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET by Rob Bovey, Dennis Wallentin, Stephen Bullen and John Green is another excellent book. But I think most beginners would find the content written at too high a level.

No matter which book your friend buys, he shouldn't expect to read it and know how to program in VBA. Programming is something you learn by doing. Advise your friend to browse through the book so he learns what is covered, then start tackling projects. When he needs more depth, read the chapter covering that topic.
0
byundtMechanical EngineerAuthor Commented:
I don't recommend learning how to program by editing recorded macros. The macro recorder teaches too many bad habits like selecting every worksheet and range before doing something with it.

That said, recording a macro is a great way to learn which objects, properties and methods are appropriate for what you are trying to do. Even today, I record macros several times a week for that purpose.

Note that Excel 2007 doesn't record chart macros, so advise your friend to use Excel 2010 or later if he has any interest in automating charts.
0
rspahitzCommented:
>Can you recommend a book, website or other source that's a good reference for VBA
commands?

I've finish an e-book, part I, on Office VBA (spanning across all the office products and how to use VBA on the various pieces) but I need to update it for 2013 before I release it.  email me in my profile if you're interested in knowing more.

>The macro recorder teaches too many bad habits
I agree, and as you implied, it's a good way to learn the API.
0
byundtMechanical EngineerAuthor Commented:
Dan Battagin, an Excel product manager at Microsoft, has requested technical community input in prioritizing development of certain features in the web version of Excel. Right now, he is most concerned with shape objects.

If you would like to participate in a short survey (two questions) to that end, here is the link: https://www.surveymonkey.com/s/HCKX7YZ

According to Mr. Battagin, "if you want to share a link publically (on your blog, tweet it, etc.), use this link. I'd like to get as many responses as possible, so don't be shy about sharing :-)"
0
mvidasCommented:
This could very well be old news, but I stumbled upon http://www.excel1040.com/ today, it is IRS tax form 1040 in Excel format.
0
byundtMechanical EngineerAuthor Commented:
As you may be aware, the site is on a campaign to eliminate blind links. But every once in a while, you see a blind link that is perfect for the situation.

teylyn did just that in http:/Q_28350854.html#a39817152  Her Comment meets the objective standard that the discussion would be helpful without the link. But by including the link, she really makes the point of her discussion: that an answer without a well-defined question isn't of very much use.

Well done teylyn!
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Thanks Brad.

Is this a bug or is it just me? When I click the link that Brad has posted, I see the top of the page with the OP's question, not the comment that Brad has linked to.

I'm using Chrome (v.Current) on Win 8.1. But it's the same in IE 11.

What am I missing? Is anyone else getting to the ANSWER post instead of the top of the question?
0
byundtMechanical EngineerAuthor Commented:
teylyn,
It was my goof.

When posting a link to a specific comment, you need to put an "a" between "#" and the Comment ID. I forgot the "a" but have patched the link up in response to your complaint.

Brad
0
gowflowCommented:
Brad

If you don't want to answer in the thread of this one
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28359071.html

pls let me know what is the problem and what you suggest to do.
Rgds/gowflow
0
byundtMechanical EngineerAuthor Commented:
gowflow,
I responded to your question in the original thread.

The site has recently implemented a policy to discourage "blind links". A blind link has no supporting discussion, and if the link were removed the Comment wouldn't have any value at all. Google treats blind links as symptomatic of link farms, and lowers the page rank of such content. In addition, if the URL changes (something Microsoft does often), then blind linked content couldn't be found by a future searcher of the Experts Exchange database.

In some TAs, comments containing only blind links are deleted by the Topic Advisor or a Moderator who happens upon the thread. In the Excel TA, I prefer to edit the Comment by adding the missing context (such as title of the web page & author's name).

Putting the code or formula in the Comment improves the quality of the discussion. The Asker can do a simple copy and paste from the webpage straight into his production workbook. Other Experts can also see that the problem is in good hands, and that they should find a different question to work on. People searching the EE database can easily see whether this thread is relevant to their immediate problem.

The way I am handling attached files isn't official site policy, but rather an initiative I have taken in the Excel TA. I am open to differing views, as long as we keep service quality foremost in mind.

Brad
0
rspahitzCommented:
you got the point :)
I like some of the discussion on the 2nd link:
"Blind links are mostly used in the pornographic sites."
"Blind links are popular with site owners that don't really mind if they trick their visitors, so long as they get some money out of them. In the longer term they can damage the feasiblity of a site."
"Theres also other terms of blind links, meaning Popup traffic, adware traffic"

And, of course, the above is how to deal with "blind links" so they're no blind.
The biggest problem I have with blind links are that they don't always lead me where I think.  For example, I've gotten some in e-mails that say something like "click here to view the report" and I click there are 1000 things, none of which look like the report I'm trying to find...until I click 2 levels deep or something like that.
And, of course, there are those blind links that work fine for the person copying, but require a login for everyone else.
0
gowflowCommented:
Brad
Tks your detailed explanation and was not aware of this level of implication in comments. Will surely ensure maximum clarity and code posted in solution on top of workbook attachments to help other users make quick decision on the outcome of the content.

Keep up the good work and thumbs up !
gowflow
0
[ fanpages ]IT Services ConsultantCommented:
...What has kept EE unique, in my not-always-all-that-humble-opinion, is that we look at more than just the question (or the comment); that we look at the person behind it, and look at the problem s/he is trying to resolve.

An excellent point, well made, rspahitz, but, unfortunately, some question askers do not appreciate this, & tend to ignore those trying to delve deeper.

Some askers are here just for a "quick fix" to a reported issue (that they may have been struggling with for a while, or may just want an answer & nothing more).

However, your comment certainly struck a chord with me.
0
rspahitzCommented:
:) I will occasionally post a link, but always try to at least give it a context.  (I never thought about people putting malicious links up, but I have found dead links and realized that you need to at least give people enough info so anyone looking at the archives can try to do a search on some of the keywords in your message.)
0
gowflowCommented:
@Netminder
I have received this on my email


Eric / Netminder has just sent you a valuable question from Experts Exchange. Click here to view the following question, or paste the following link into your browser: http://rdsrc.us/ci2Osv

Any chance it sent by you ? I usually don't open such links !
gowflow
0
byundtMechanical EngineerAuthor Commented:
gowflow,
Netminder's email uses the Red Source URL shortener, the same as links in the Experts Exchange newsletter. It resolves to the question "GP 2010 Fiscal Periods" http:/Q_28351766.html  This is not an Excel question, but it may still be one that you can help with.

Brad
0
gowflowCommented:
tks byundt
although almost chineese to me but will give it a try.
gowflow
0
gowflowCommented:
Netminder

You over qualified me on this one ! :) tks your appreciation which is always nice to hear.

Regards
gowflow
0
gowflowCommented:
Netminder,

Not to brag, but truly for me what get me going is to know that my input can help someone. Unfortunately, sometimes it goes against your own interest of optimizing your time spent effectively and productively.

One thing for sure I can confirm and never cease to repeat whenever possible is that we have here (I mean EE altogether philosophy, attitude, system, rules, conduct etc...) a gold mine which is hard to find elsewhere and should be preserved well, and this for sure thanks to all the good volunteers like you who spend time and effort building this up one brick at a time.

Call me idealistic to dreamer maybe !
gowflow
0
mvidasCommented:
In case you've ever wondered why the logo for excel is an X ...
office logos(stolen from reddit)
0
byundtMechanical EngineerAuthor Commented:
Matt,
That's subtle.
Brad
0
zorvek (Kevin Jones)ConsultantCommented:
The perceived degree of lack of subtlety in the context of this subject is directly related to the degree of closeness of one's mind to the gutter.

;-)
0
gowflowCommented:
So we can say: WE Make the difference !!! :)
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I give up.

I found the original reddit post.

Still, no clue.

Must be a cultural thing.

Edit: For real? I mean, you all get hung up about a series of icons that almost, but not quite, spell out the name of a body part?

How do you all live without blushing?

If you are male,  don't you have a penis? If you are female, don't you have ...

OK,  pull  back, ... this site is US centric ... I cannot expect that US folks actually call their finger nail a "finger nail" or their penis a "penis". It might be offensive to put a name to a body part.

That's why baby formula was invented, right? So nobody had to think about "breasts" and "breast milk".

So, a series of icons featuring letters that just manage to fail spelling a male body part is big news?

That can only be remotely funny if the reader is a drop-dead conservative who never acknowledges that there is a body that needs to eat, drink,  and do a lot of other things,  including sexual interaction.

What are you afraid of? What kind of religious education has inflicted such damage on you, that you are shy to use a word for a body part that half of the population possess?

Publisher
Excel
OneNote
InfoPath
SharePoint

Makes PEOIS. So, is the fault with the product names or the letters in the icons? (X for Excel, N for OneNote)?

Regardless of that, someone took selected letters of the products to come up with an incorrect acronym, which MAY look like the name of a male body part.

Big deal.

When will that someone grow up and stop giggling whenever a breast or a penis is mentioned?

Man, do you folks need to grow up. This is such cramped suppressed sexuality. Do you all also laugh when someone says "fart"? It's about the same level of intellect.

You may want to read Kurt Vonnegut's "Galapagos" - Spoiler: the most offensive talk is about farting.
0
mvidasCommented:
I think it is less about cultural differences, and more about basic maturity (or lack thereof).

I spend a lot of my time with a little girl who giggles every time I say the word poop or make a farting noise with my mouth, which makes me laugh right back. A big part of me likely never made it beyond 5th grade.
0
zorvek (Kevin Jones)ConsultantCommented:
Teylyn,

Humor is very subjective. Humor seems to be more humorous when there is a certain degree of exclusivity - an unstated awareness that only a select number of people will "get it". But if that number of people is too small the "joke" falls flat as they say. Too large and the "joke" is boring. Subtlety is part of the art of creating that exclusivity.

Take the comment following mine: "That's what happens when one deals with peninsula Excel Experts for too long." This is clearly an "inside" joke that few will get. It's, for the most part, between Erik and me, just as my comment was directed at him.

So any reference to the potty or sex or genitalia is usually more humorous to the male brain than the female brain. Male brains do not evolve as quickly as female brains and parts of the male brain tend to get stuck in an adolescent state. I'm in my 50's and hang out with other men in their 50's and older. When it's just men, the low end of the quality of the humor can easily drop to the gutter and worse. As soon as women are in the mix, the low end gets significantly higher.

Jerry Seinfeld never uses any profanity or potty humor and he is very funny. Don Rickles uses insults to get laughs. Johnny Knoxville is all about the vulgar and potty. They are all funny in their own ways and with different audiences.

When I raised my daughter I raised her with a wicked sense of humor. And we thought farting was a most hilarious thing. But, and I made this very clear, never fart in front of mama or, God forbid, grandmother, as that would have had the opposite effect. And that made farting all the more special - and funny ;-)

As far as the Excel joke above, it's a little twisted, very subtle, and more geared to the tweeky immature male geek mind. It's a long stretch too. That Erik found it as subtle as a "tank hitting a cinderblock wall" is telling in and of itself ;-) ;-) Brad's comment was more socially adept. Matt is an artist when it comes to subtle humor. So is Nigel.

For me, the real humor is reading between the lines of the responses.

Kevin
0
gowflowCommented:
Teylyn,

I only hope mine was not misunderstood, as by WE, I did not mean WE as 'male' or 'man' but definitively 'WE' as we all are and have in common here in this forum, 'WE' as the Excel people  ... ! WE Make the difference !!! :)

I only hope I didn't offend any one as thought these icons were really coincidentally funny, and to add ... have 3 kids also and am in the 50's and joke all the time (not the bad vulgar way which I despise) but the silly way as believe life without humor is not worth living.

gowflow
0
zorvek (Kevin Jones)ConsultantCommented:
That, sir, will have to wait until you and I are in the same physical space sitting at a dinner table.

:-)

Side note: I am actively working with a man named Erik, not Eric. THAT "mistake" was unintended.
0
zorvek (Kevin Jones)ConsultantCommented:
Like a tank hitting a...oh, never mind.
0
rspahitzCommented:
HAHA...Teylyn said breast and fart :P
(Oh and thanks for clarifying the image since apparently my mind was not in that gutter today.)
0
zorvek (Kevin Jones)ConsultantCommented:
Same here. It took me a minute or two to figure it out. Others seem to be more adept at seeing those words buried in the mundane. And, as Teylyn pointed out, "OneNote" puts a kink in the subtle logic requiring yet more of an affinity to the gutter in order to get it.

I'm reminded of those who so easily see the image of Jesus in tree bark, scrambled eggs, and spilled beans on the floor - they WANT to see and are LOOKING for the image.

And then there are those who are proud of this skill and pronounce their aptitude.

Hmmm...
0
aikimarkCommented:
@teylyn

1. The US is so puritanical they use "white meat" and "dark meat" terms when ordering cooked chicken, rather than saying breast or thigh/leg.

2. All men are still six years old and laugh at the same puerile humor.

3. See Rule 34

4. Some great comedy bits throughout history have been based on farts.
0
nutschCommented:
Quit farting around: Saurabh is back! Feels like old times.
0
zorvek (Kevin Jones)ConsultantCommented:
Yep! That's him! His signature misuse of the ellipsis is stinking up the joint.
0
[ fanpages ]IT Services ConsultantCommented:
Humo(u)r-bypass alert!

Teylyn: As the saying goes...

"The Internet: where men are men, women are men, & children are FBI agents".

Instead of farting around, I am going to write to the site staff to ask for funnier thread content.

My Pen Is In My Hand Right now.  I hope I don't feel a right tit if "finger nail" is something rude.
0
JohnBusiness Consultant (Owner)Commented:
This thread:

http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_28372251.html

Can an expert here help the asker?  Apparently they have a Name in Outlook that is 3 Outlook names (Name 1, Name 2 and Name 3) each with a separate phone number. He wants to merge the phone numbers into one contact.

So I think Excel is the tool. Export the contacts. Add field columns, Macro to move record 2 field 1 to record 1 field 2, move record 3 field 1 to record 1 field 3 and delete superfluous records.
0
[ fanpages ]IT Services ConsultantCommented:
John/All: Kevin seems to be working on this problem in the question thread below...

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28372256.html ]
0
JohnBusiness Consultant (Owner)Commented:
I saw that. Thank you Kevin.

I answered another question of this asker - not Excel. I could only get close but what I was suggesting would at least work. The asker was ticked that I even responded. Oh well.
0
nutschCommented:
A big shout-out to barry, who came out of nowhere with array formulas a little more than five years ago and just passed five million points in the excel zone, teaching most of us (or at least me) quite a few tricks in the process.

Thanks barry and Congrats!

Thomas
0
rspahitzCommented:
Congrats Barry.  Great job!  Is 10mil right around the corner?
0
byundtMechanical EngineerAuthor Commented:
I too have learned much from barryhoudini's formulas. Among other things, he has taught me the power of LOOKUP to ignore error values and avoid array-entering a formula, the use of MEDIAN in time & date formulas, and ISNUMBER(SEARCH.... in text parsing. Those are powerful tools wielded by a master.

Congratulations barryhoudini. Woohoo!
0
byundtMechanical EngineerAuthor Commented:
Mashable has a nice article on the development of Office for iPad. The gestation period was two years or more, and Han-Yi Shaw used that time to sweat the details about what to include, what to leave out, and how to make work just the way users would like on the iPad. Mr. Shaw also mentions that Office 365 has been through 72 updates since its release, with features being added regularly. That's a good prognosis for the future of Excel for iPad. http://mashable.com/2014/03/27/microsoft-office-ipad-story/ 

Microsoft Excel MVP Bill Jelen has made a detailed list of what works and what doesn't in Excel for iPad. The following is a quote from an email he sent out:

"This link has my list of everything that I found that works and does not work, as well as a long video with demos of the features:
http://www.mrexcel.com/learnexcel/2014/03/28/excel_for_ipad/

Overall, it is an impressive list of features you can create right on the iPad, then even more that render on the iPad when created on the PC.

 Natively works on iPad
 Create on the iPad
 Enter data
 Format data
 All colors
 Cell Styles
 Shapes
 Charts
 Pictures
 Merge Cells
 Insert/Delete Cells/Rows/Sheets
 Sort
 Filter (but no Search box in Filter dropdown)
 Formulas

 Works on iPad if created on PC
 More Charts
 Pivot tables
 Sparklines
 Conditional Formatting
 Validation
 Array Formulas
 SmartArt
 WordArt
 Screen Clipping
 Static Camera Tool

 Not supported at all:
 VBA Macros
 No Power Pivot (and no External connections)
 Excel 2013 Slicers on regular Tables
 Timeline Slicers

 These two, it seems like they should be working, but I can not get them to render:
 Hyperlinks to Navigate between sheets
 Pivot Table Slicers

 For table slicers, a box appears saying "We can't show you this item. Don't move this box". But for Pivot Table slicers, they just aren't showing. Since there is not a box, I am doing something wrong.

 Hyperlinks: A link to Sheet1!A1 or even to MyNamedRange is not working. But there is a lot of Hyperlink UI in the app, so it really seems like it should be working."
0
rspahitzCommented:
I hope the ipad implementation is better than the imac implementation, which is pretty inadequate once you get used to working with Excel in Windows.  For example, the handling of formula validation is miserable compared to windows.
0
byundtMechanical EngineerAuthor Commented:
Did you ever want to ask a question straight to an Excel product manager? Here's your chance.

Microsoft is hosting a reddit "AMA" meeting on Friday April 4 at 4:00 Eastern (Daylight) Time. Dan Battagin, Defender of VBA and an all-around great guy, will be on tap.

For particulars, see the Microsoft Excel Blog at http://blogs.office.com/2014/03/31/join-us-april-4-excel-ama-on-reddit/ 

Feel free to spread the word.
0
rspahitzCommented:
Well I guess the new UI is in.

Not sure why developers think that by making you click MORE that you'll enjoy the experience better.

Specifically, the panel that used to be on the right side to let me select the topics I visit frequently is now hidden inside a toolbox so I have to open the toolbox then open the topics section then pick the topic I want to see.  So I am now 50% less productive and less likely to want to go work in any particular topic area since it's that much more effort to go there.

Does anyone know of a "shortcut" that can be placed to just directly to my topics of choice rather than go through 3 clicks just to see if there's anything I want to help with?
(For volunteer work, I don't like working harder to accomplish the same thing!)
0
aikimarkCommented:
This thread is taking a noticeably long time to load.  I suggest a new thread, Brad
0
byundtMechanical EngineerAuthor Commented:
Does anyone know of a "shortcut" that can be placed to just directly to my topics of choice rather than go through 3 clicks just to see if there's anything I want to help with?
Would a filtered list of open questions be of use to you? I keep mine as a clickable icon on my browser menu bar, for one-click access to questions of interest. http://www.experts-exchange.com/searchResults.jsp?searchId=95352 

If you want to build one like that:
1.  Check the box for "Question" on the Advanced Search page http://www.experts-exchange.com/advancedSearch.jsp 
2.  Click the "Add" link to the right of ? Topics, then choose the topic areas of interest
3.  Click the "Add" link to the right of ? Question status, then specify "Open"
4.  Change the default under ? Results per page from 10 to something more reasonable like 100 or 200
5.  Under ? Display, choose between Detail View and List View. Detail View shows fewer questions in a screen, but gives you the opening few lines of each question. List View is one line per question.
6.  Check the box at the bottom to "Save this search"

You should see a list of the questions in your chosen topics, with most recently opened listed first.
0
rspahitzCommented:
N, how do I do saved searches in less than 3 clicks? (before it was 2 click to open topics and pick one, but now it's 3 because I have to open the toolbox first, and it looks like saved searches are in the toolbox too...)

Brad,
I'm not sure that filtered lists would help unless I can recall it on demand for any particular browser I happen to be visiting.
Also, can I get a nice summary list like the "normal" listing (although the synopsis list looks interesting.)

Maybe I just never worked with this feature and don't know how to use it properly.  

So starting from experts-exchange.com (assuming I'm logged in), what's the best way (fewest clicks) to get to any particular topic of my choice, such as Excel?  Previously, it was 2 clicks since I had already set up "My Topics".
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
byundtMechanical EngineerAuthor Commented:
I put an icon for my saved search in the menu bar of all five browsers that I use on my laptop. I use them instead of links to the Experts Exchange web site or the Excel TA. That gives me one-click access to open questions.

When building your search, you can choose between Detail View and List View. The Detail View is the synopsis listing, while List View is the classic compact list. This option is at the bottom under ? Display.

I edited my previous Comment to show this choice. Thanks for reminding me Rob!
0
byundtMechanical EngineerAuthor Commented:
This question is taking a little longer to load with the new site format. Thanks aikimark for bringing it to my attention!

I opened a new one at http:/Q_28428578.html

Brad
0
mvidasCommented:
How do I subscribe to the new topic without posting on the new UI?
0
mvidasCommented:
Thanks, apparently my eyes ignored the grey footer bar.
0
aikimarkCommented:
I only see Tweet, Facebook, LinkedIn, Google+, Link, and Email links in the page footer.  I have reported this.
0
Saqib Husain, SyedEngineerCommented:
Hi, I see that this question is closed. Is this discussion continued elsewhere?
0
aikimarkCommented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.