+ Reply to Thread
Results 1 to 10 of 10

Lösung über Formel oder VBA

  1. 02-17-2015, 04:32 AM #1
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Wink Lösung über Formel oder VBA

    Hallo liebe community,
    I have a big problem and sit here in my büro since last week =(
    I need a Formula or a VBA code.

    I have 2 Zells and 1 table. In the table i have release with different countries and for every country a different times with releases.

    First Cell is my outdoor time. Second cell is my country. I need a comparison beetwen the both Zells and the table in a third Cell.
    Ähmmm... the table is in german, but i think that this isnt a problem because its an easy configuration.

    Please help me

    Test.jpg
    Reply With QuoteRegister To Reply
  2. 02-17-2015, 06:32 AM #2
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    http://www.filedropper.com/test_129

    here is the file from the excel-Date
    Reply With QuoteRegister To Reply
  3. 02-17-2015, 06:33 AM #3
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    http://www.filedropper.com/test_129

    here is the file from the excel-Date
    Reply With QuoteRegister To Reply
  4. 02-17-2015, 07:07 AM #4
    tigertiger
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Lösung über Formel oder VBA

    Hallo

    This is an solution
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    note: attention this one is array formula so you need press Strl+Shift+Enter (Strl=Ctrl) to input the formula - instead of only Enter (normal formula)

    and Plz see the attached file: added 2 dummy columns for Land and formel, of course you can put them hidden
    Attached Files Attached Files
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.
    Reply With QuoteRegister To Reply
  5. 02-17-2015, 07:19 AM #5
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    OK, THX
    But i found a false.
    If you put in Example Belgien and put 20h, than the outcome must be 27. And the table show me 0 =(
    Reply With QuoteRegister To Reply
  6. 02-17-2015, 08:10 AM #6
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    nobody an idea??
    The formel is good, but the LOOKUP dont said allwaays the right "sences"
    Reply With QuoteRegister To Reply
  7. 02-17-2015, 08:24 AM #7
    tigertiger
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Lösung über Formel oder VBA

    Quote Originally Posted by eugen.hasilbach View Post
    nobody an idea??
    The formel is good, but the LOOKUP dont said allwaays the right "sences"
    now, we use normal formula for the result cell

    see the attached file, subsidiary columns at N and O columns (see new data at O column)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 02-17-2015, 08:29 AM #8
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    fine!!!!!
    thank you !!!!
    tigertiger you are the best!!!!
    Reply With QuoteRegister To Reply
  9. 02-17-2015, 08:41 AM #9
    tigertiger
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Lösung über Formel oder VBA

    Quote Originally Posted by eugen.hasilbach View Post
    fine!!!!!
    thank you !!!!
    tigertiger you are the best!!!!
    if you are sure that: in Tabelle Auslösung, only Deutschland contains 5 rows but others 3 rows, you can use the short formula for L5 (IF not sure plz use the old formula (longer))

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 02-17-2015, 09:18 AM #10
    eugen.hasilbach
    eugen.hasilbach is offline
    Registered User
    Join Date
    02-15-2015
    Posts
    7

    Re: Lösung über Formel oder VBA

    the second formula is better
    super? thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. arrayformel über mehrere Tabellenblätter
    By Blockus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 10:53 AM
  2. arrayformel über mehrere Tabellenblätter
    By Blockus in forum Non English Excel
    Replies: 0
    Last Post: 01-22-2015, 10:35 AM
  3. Formel for top 3
    By R.Gaard in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-28-2014, 05:03 PM
  4. [DEUTSCH] Probleme bei der Findung der richtigen Formel
    By Furyios in forum Non English Excel
    Replies: 1
    Last Post: 05-07-2014, 10:27 AM
  5. Sortieren über mehrere Sheets
    By LowFat in forum Non English Excel
    Replies: 5
    Last Post: 10-31-2008, 06:27 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1