Need some complex formulas

arnolju

New Member
Joined
Nov 27, 2005
Messages
9
DATE AMOUNT CHF-USD E VENT SUCCESS - 2 SUCCESS - 2 DAY
22/09/86 1.637
23/09/86 1.6616
24/09/86 1.6575
25/09/86 1.6625
26/09/86 1.66
29/09/86 1.6425
30/09/86 1.6455
01/10/86 1.6442
02/10/86 1.6325
03/10/86 1.616
06/10/86 1.621
07/10/86 35 1.634 START
08/10/86 1.6281
09/10/86 1.6315
10/10/86 1.6192
13/10/86 1.614
14/10/86 100 1.615 END 1 1 -0.959% 1.733%
15/10/86 1.6135
16/10/86 1.6175
21/10/87 1.5025
22/10/87 1.5015
23/10/87 1.4935
26/10/87 1.46
27/10/87 1.4585
28/10/87 100 1.441 START
29/10/87 130 1.429
30/10/87 1.4285
02/11/87 60 1.42
03/11/87 1.4135
04/11/87 1.4085
05/11/87 1.3825
06/11/87 30 1.376
09/11/87 1.368
10/11/87 30 1.363 END 1 1 3.062% 6.001%
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Here is one. Not sure what you are looking for though.

Code:
=IF(ROW()-ROW($F$3)+1<=$F$1,INDEX($B$3:$B$7,MATCH("*"&LOOKUP(ROW()-ROW($F$3)+1,$D$3:$D$6,$C$3:$C$6)&"*",$B$3:$B$7,0)),""
 

Watch MrExcel Video

Forum statistics

Threads
1,119,264
Messages
5,577,060
Members
412,763
Latest member
sienweiw
Top