Closed Thread
Page 5 of 5 FirstFirst ... 5
Results 801 to 822 of 822

Call in the cavalry -- need help solving this thread-prior to 2013

  1. #801
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Call in the cavalry -- need help solving this thread

    Anybody up for this one, the OP might be getting a tad impatient, I think it's now urgent! ...
    bill of material (multi)

  2. #802
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Call in the cavalry -- need help solving this thread

    Can't come up with a formula that gives the required value for this one.

    http://www.excelforum.com/excel-gene...-database.html
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #803
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Call in the cavalry -- need help solving this thread

    Anyone for VBA solution here?

    http://www.excelforum.com/excel-prog...mat-macro.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #804
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,366

    Re: Call in the cavalry -- need help solving this thread

    Looks like I've shattered someone's illusions.

    Can anyone throw a positive light here:

    http://www.excelforum.com/excel-gene...y-desktop.html


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #805
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread

    This old thread the OP is back, and short of just creating four separate formulas for each pair of cells, looking for a creative elegant solution like DDL's original suggestion but that actually handles all the variations.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  6. #806
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread

    This OP has a unique data reformatting project?

  7. #807
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Call in the cavalry -- need help solving this thread

    I am hoping someone can help out with this post:

    http://www.excelforum.com/excel-prog...cell-loop.html

    I have gone about as far as I can (which isn't all THAT far). My original code kind of/sort of did what he asked, but his follow up posts added more requirements that I am not knowledgeable enough to answer.

    - Moo

  8. #808
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Call in the cavalry -- need help solving this thread

    Having real difficulty in understanding what this OP is trying to do. Perhaps you will understand better.

    http://www.excelforum.com/excel-gene...-one-cell.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #809
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Call in the cavalry -- need help solving this thread

    Can someone help with a formula solution here ? http://www.excelforum.com/excel-form...ssignment.html

    I jumped into the thread not seeing that the OP was looking for a formula solution.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  10. #810
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Call in the cavalry -- need help solving this thread

    anyone gopt any ideas for this OP?

    http://www.excelforum.com/excel-form...html?p=3055687
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #811
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the cavalry -- need help solving this thread

    Good chance (very good chance) there is an easier way to do this, but it seems I have a decent working solution outside of "B-InterfaceUnit" being counted twice.

    I have not posted the workbook yet to the thread as it's not complete, but would anybody be so kind as to give me a helping hand?

    Count should be 74 and because of the dup I'm getting 77

    Attached is my working model.
    Attached Files Attached Files
    HTH
    Regards, Jeff

  12. #812
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the cavalry -- need help solving this thread

    Any thought on where to go with this?

    http://www.excelforum.com/excel-gene...ged-cells.html

  13. #813
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the cavalry -- need help solving this thread

    Anybody have some thoughts on this cut, copy, and paste thread?

    http://www.excelforum.com/excel-prog...worksheet.html

  14. #814
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Call in the cavalry -- need help solving this thread

    maybe some=one here can figure this 1 out, i sure cant
    http://www.excelforum.com/excel-prog...html?p=3060333

  15. #815
    Registered User
    Join Date
    12-22-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Call in the cavalry -- need help solving this thread

    http://www.excelforum.com/excel-prog...-inserted.html

    Hi All. I am S.T.U.C.K. on this. Please review and advise if you have any suggestions. I think my last post on the thread explains where I am at.

  16. #816
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the cavalry -- need help solving this thread

    Hi John,

    I think you missed the intention of this thread. This thread is not for an OP to personally place a message asking for help; rather, it is designed for a member who is helping an OP to ask for further assistance when they get stuck.

  17. #817
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Call in the cavalry -- need help solving this thread

    Can anybody come up with a reasonable explanation for why the advanced filter will not work?

    Thought I found a solution, but it keeps bugging on...

    Please Login or Register  to view this content.

  18. #818
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    I just discovered this thread. I think I'll come here first from now on. Starting tomorrow.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  19. #819
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    Or perhaps start here at the current thread:

    http://www.excelforum.com/the-water-...3-onwards.html

  20. #820
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    I think M. Beaucaire has given me good direction - It would be nice if every thread initiator would edit the thread to say that it's been solved before "Ragtime Cowboy Joe" tries to ride to the rescue - tres frustrating

  21. #821
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    Yeah, that's smart. With that link in post #819 (whew!), we'll retire this thread now.

    Good night to 2012...

  22. #822
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Call in the cavalry -- need help solving this thread-prior to 2013

    Those interested in Cavalry calls should consider subscribing to the new thread located here:
    http://www.excelforum.com/the-water-...5-onwards.html

Closed Thread
Page 5 of 5 FirstFirst ... 5

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