Search:

Type: Posts; User: Stefyu89; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    34,022

    Re: Modeloff Round 2 Case Study Time is Money

    Hey bit toooooo late but anyway and sincerely thanks for taking the time to answer to this problem and leaving your model on dropbox till now !!! Truly appreciated !!!!

    Cheers
    STEPHANE
  2. Replies
    6
    Views
    53,633

    Re: Snakes and Ladders Simulation Qs

    Actually we have the same answers !!! My bad !!! Thanks again for your spreadsheet !!! Learn a lot trough tackling these case studies !!!
  3. Replies
    6
    Views
    53,633

    Re: Snakes and Ladders Simulation Qs

    I have tried your approch and use data table to simulate the 5000 game simulation. My answers don't match yours, at least for the very first questions. Need an expert eye to enlighten me concerning...
  4. Replies
    13
    Views
    854

    Re: separation of numbers and text

    Hello,

    For the sake of providing multiple approaches to tackle the same issue, these are my macros (Not so brillant as RegExp expressions from Hiker 95 but .... ) :

    Function Numbers (txt As...
  5. Re: extracting data of ROW by conditional check of one column

    this is a formula who can answer your request :

    =IF(ROWS(A$17:A17)>COUNTIF($G$1:$G$10,$B$14),"",INDEX(A$1:A$10,AGGREGATE(15,6,(ROW($A$1:$A$10)-ROW($A$1)+1)/($G$1:$G$10=$B$14),ROWS(A$17:A17))))
    ...
  6. Replies
    3
    Views
    34,022

    Modeloff Round 2 Case Study Time is Money

    Before everything, thanks to Modeloff team for having provided the questions for the rest of the world sooner than the previous editions of this championship. It's a valuable help in my...
  7. Re: ***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

    @ Aladin

    Thanks a lot Aladin for pointing me to some useful references. Meanwhile, i was already aware of this "Big Value" lookup method through you, actually through Mike Excelisfun Girvin who...
  8. Re: June/July 2008 Challenge of the Month

    i've got one which is less lenghty : =RECHERCHE(2;CHERCHE("*"&$B$7:$B$9;A13);$C$7:$C$9) ( recherche : french for lookup and cherche : french for search).
    The array after evaluation, always gives...
  9. Replies
    3
    Views
    531

    Re: lookup and prorata calculations

    Thanks for your quick answer but not what i'm looking for.

    As an illustration, if in January you got 14 of revenue : you must get 15% for the first 10th of revenue plus a prorata of between 11-20...
  10. Replies
    3
    Views
    531

    lookup and prorata calculations

    i've a question concerning a lookup on a list of rate of return for this 3 hurdles level of earnings. You must calculate the proper rate of return for different rate and use prorata for earnings...
Results 1 to 10 of 10