Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 23

Thread: INTERSECT in Excel

  1. #11
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Anne Troy View Post
    And I heard you laugh just then, Zack.
    That might have been me.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #12
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    There is always Office Web Apps, which are free with a Live ID or Hotmail account. Although I don't think they support Data Validation either. It gets tough in a web browser. But I like them better than Google Docs personally.
    Regards,
    Zack Barresse

  3. #13
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by Zack Barresse View Post
    Although I don't think they support Data Validation either.
    They don't, and personally I think this is the biggest miss of the webapp product. The whole point of the webapp is to consume information, yet we can't sanitize the data inputs.

    I really hope Microsoft is working on this for the next release, as it's a big piece in the equation.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #14
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Definitely AGREED!!
    Regards,
    Zack Barresse

  5. #15
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    401
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by Ken Puls View Post
    They don't, and personally I think this is the biggest miss of the webapp product. The whole point of the webapp is to consume information, yet we can't sanitize the data inputs.

    I really hope Microsoft is working on this for the next release, as it's a big piece in the equation.
    It's possible that the missive was deliberate, getting such things to work cross browser compatible must be a huge headache, even plain old websites don't render the same in every browser, i would also imagine that allowing the use of either native or VBA code to manipulate the app may also pose a huge security risk, although that said i did spot somewhere on the net running excel on linux and directly in a website , now thats something i would consider much more useful than webapp for training and problem solving purposes but not for the display and accessibility of a closed usergroup like SkyDrive enables.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  6. #16
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Closed group? It's not a closed group. LOL! It's free for anybody.

    But I think you're right about the web browser. I'm happy with what we have, but wish for more.
    Regards,
    Zack Barresse

  7. #17
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    401
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by Zack Barresse View Post
    Closed group? It's not a closed group. LOL! It's free for anybody.

    But I think you're right about the web browser. I'm happy with what we have, but wish for more.
    You misunderstood me, i have files in SkyDrive but you can't see them, only the people i have allowed - thats what i meant
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  8. #18
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,319
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by Simon Lloyd View Post
    It's possible that the missive was deliberate, getting such things to work cross browser compatible must be a huge headache, even plain old websites don't render the same in every browser
    Fair enough, but it still doesn't mean it doesn't need to be built.

    Quote Originally Posted by Simon Lloyd
    i would also imagine that allowing the use of either native or VBA code to manipulate the app may also pose a huge security risk
    Worse than that even. Based on what I got from MS, it's not threadsafe for multi-threading. This would have the potential to bring down your server. To my understanding, VBA will never work on the web.

    although that said i did spot somewhere on the net running excel on linux and directly in a website , now thats something i would consider much more useful than webapp for training and problem solving purposes
    I can actually do this today using a published Excel application on citrix (although you'd have to clear login hurdles and such.) It basically runs over RDP.

    I guess the thing to me here is that I don't see the webapp isn't really designed as a tool for training purposes like we're doing. I see it as a tool designed for consuming reports interactively, and also for allowing live files on websites. (Say build your own quote, or work with your canned data to show sales for a day.) Ultimately, that data validation needs to be there. At a bare minimum, we need to have the ability to use Excel's native data validation rules/lists.

    Just my 2 cents though.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  9. #19
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    I think they're great for probably the majority of Office users. I don't know what the percentages are of what features people utilize the most, but I'd be willing to bet that almost everybody could find a user for OWA. And if they're looking for either a cheap or free alternative, I think it beats OpenOffice and the likes. It's somewhat painstaking because it's free and not many people know about it. Sure you can't do everything you do in the full-blown app, but surely that has to be understandable. ?
    Regards,
    Zack Barresse

  10. #20
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    401
    Articles
    0
    Excel Version
    Excel 2016
    Zack, i'd give yionou the "....surely that has to be understandable.." but as Ken points out it is severely lacking in native functions, sure it's pretty, you can display data (well most of it), can use formulae but the interface doesn't allow for the kind of collaboration that it should without downloading or opening the workbook doesn't email do that? ..........I know i'm splitting hairs.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •