+ Reply to Thread
Page 11 of 11 FirstFirst ... 9 10 11
Results 151 to 156 of 156

Call in the Cavalry - 2017

  1. #151
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    2,364

    Re: Call in the Cavalry - 2017

    I started this but now I'm backing out. Yes there is a (poor) language issue but he did provide sample answers in the cell comments. Not sure if he's asking to much of a formula though.
    https://www.excelforum.com/excel-for...hole-cell.html
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #152
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    10,700

    Re: Call in the Cavalry - 2017

    Array issue
    https://www.excelforum.com/excel-pro...ect-field.html

    OP loops through array, the 8th column always comes up before the 9th column
    Please Login or Register  to view this content.

  3. #153
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,538

    Re: Call in the Cavalry - 2017

    Anybody have some suggestions on this filtering thread?
    HTH
    Regards, Jeff

  4. #154
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    2,951

    Obtaining Hyperlink for file on DropBox

    Relating to this thread: https://www.excelforum.com/excel-pro...k-element.html

    Locally the (alias) path to a file saved to dropbox looks like this:
    C:\Users\kev\Dropbox\Penguins.jpg
    (this is known)

    The true path is:
    https://www.dropbox.com/s/txqf5cnhr7...guins.jpg?dl=0

    It's possible to get that path by
    - navigate to file in File explorer
    - right-click on the file
    - click option Copy Dropbox link
    - the value returned is the true path

    dropbox.jpg


    What I would like to be able to do is to write some VBA to lookup the alias and return the true path
    Does anyone know how to do that?

    thank you
    Last edited by AliGW; 12-11-2017 at 02:16 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  5. #155
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    2,364

    Re: Call in the Cavalry - 2017

    Iím out of time. Some nice VBA loops to be added here:
    https://www.excelforum.com/excel-pro...positions.html

  6. #156
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,741

    Re: Call in the Cavalry - 2017

    This one has gone beyond the basic filtering that I readily know how to do. I'm sure if pressed I could figure out how to read the result of the filter into variables then put together the message box the OP wants, but I expect that many of you know better how to extract the information the OP wants and output it in a format more like what the OP wants. I also don't know and can't test what dflak's slicers can do in this regard.
    https://www.excelforum.com/excel-pro...-how-many.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread
Page 11 of 11 FirstFirst ... 9 10 11

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1