# Search:

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

1. ## Thread: Modeloff Round 2 Case Study Time is Money

by Stefyu89
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

by Stefyu89
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 !!!

by Stefyu89
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. ## Thread: separation of numbers and text

by Stefyu89
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. ## Thread: extracting data of ROW by conditional check of one column

by Stefyu89
Replies
21
Views
1,974

### Re: extracting data of ROW by conditional check of one column

=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. ## Thread: Modeloff Round 2 Case Study Time is Money

by Stefyu89
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. ## Thread: ***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

by Stefyu89
Replies
306
Views
196,574

### Re: ***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

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. ## Thread: ***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

by Stefyu89
Replies
306
Views
196,574

### 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. ## Thread: lookup and prorata calculations

by Stefyu89
Replies
3
Views
531

### Re: lookup and prorata calculations

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. ## Thread: lookup and prorata calculations

by Stefyu89
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